Table and Macro Access 2002

[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...

 

[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...

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!