Table and Macro Access 2002

  • Thread starter Thread starter Lazaros
  • Start date Start date
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...
 
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!
 
Back
Top