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/
 

Reply via email to