J jim branum Aug 19, 2003 #1 how do i build a macro button to copy the info to a new record from current form displayed
S Steve Schapel Aug 20, 2003 #2 Jim, In a nutshell: Make a query which selects the record as displayed on the current form. Make it into an Append Query. Make a macro using the OpenQuery action to run the append. Assign this macro to the Click event of your button. - Steve Schapel, Microsoft Access MVP
Jim, In a nutshell: Make a query which selects the record as displayed on the current form. Make it into an Append Query. Make a macro using the OpenQuery action to run the append. Assign this macro to the Click event of your button. - Steve Schapel, Microsoft Access MVP
