Macro to add record and run query

lydz

Registered User.
Local time
Today, 14:00
Joined
Mar 6, 2006
Messages
28
hopefully this'll be a really easy thing that will be a bit embarrassing, bit quick

anyway i have a button (on a form) and using the wizard have got it to add a new record
and have a seperate update query for something and thought itd be handy if the button could run that query as well, so immediately thought of macros and just to have the button run the macro
so gone to make a macro and got it to run the query easy, only thing i havent seen in the things that the macro will do is add a new record
does anyone know how to make the macro add a new record?
cheers
not too experienced with macros as im sure you can tell
 
Select GOTORECORD in the Action Column of the Macro. Select the Object Type: form, query, table, etc; Select Object Name <Name of the form, query or table> and RECORD = NEW.

That should do it

Goh
 

Users who are viewing this thread

Back
Top Bottom