Table and Macro Access 2002

L

Lazaros

How can a macro run only one time, when a new record add
to a table?

Database: Acer
Table: tblFim
Fields = Tok_ID, Title, Ahor_ID
Macro: mcrnew

Any help would be greatly appreciated.

Many thanks...
 
J

John Vinson

How can a macro run only one time, when a new record add
to a table?

Database: Acer
Table: tblFim
Fields = Tok_ID, Title, Ahor_ID
Macro: mcrnew

Any help would be greatly appreciated.

Many thanks...
Click to expand...

Tables have no useable events. I'd suggest using a Form to add the
records; the Form has a BeforeInsert event in which you can put the
macro (or, better, convert the macro to VBA and use an [Event
Procedure].

As a rule, table datasheets should be used ONLY for design and
debugging - they have very limited capabilities!
 
Top