1) i hope i understand you correctly. Put this under a command button click
event:
me.fieldA = me.fieldX
me.fieldB = me.fieldY
me.fieldC = me.FieldZ
... sorry I dont use filter form and macros
hth
george
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED]
Behalf Of david200207
Sent: Tuesday, October 17, 2006 11:19 PM
To: [email protected]
Subject: [ms_access] Macro help etc.
I have 2 problems to solve with a database i have contructed:
1)I need a macro button creating on an existing form to carry out the
following
( cut and paste data from field A to field X
ditto for filed B to field Y
ditto for filed C to field Z)
2)I am able to filter by form , clear filter ,type in data and then
apply the filter in the usual way but can this be wrapped up into a
single button to save time ?
Thanks in advance for any help
David
Yahoo! Groups Links
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/ms_access/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/