How to trap the creation of a new record ???

  • Thread starter Thread starter Terry Burns
  • Start date Start date
T

Terry Burns

i'm a newbie here. I want to create a related record for each new record
created. IE everone has a birthday, so for each new person created, I want
to create an event record regarding their birthday. I have used the standard
form wiz to create the form from the table.

Now i need to trap the create event ( or whatever its called ) how can I do
this ?

Regards - Terry
 
i'm a newbie here. I want to create a related record for each new record
created. IE everone has a birthday, so for each new person created, I want
to create an event record regarding their birthday.
Click to expand...

ummmm... no. Not for a birthday, certainly! Just store the date of
birth in a field named DOB in the record. What information would you
be storing in the "birthday" table?

It is almost NEVER appropriate to create a "placeholder" record in a
second table. When you have data to put into a related table, use a
Form (based on the main table) and Subform (based on the child table),
add the data, and let the master/child link field fill in the person's
unique ID - but don't create the record before you have something to
put into it!
 
OK

Thnks 4 ur reply, but this still does not answer the question. Can u trap
the creation of a new record other than by programatically creating it ?

Regards
 
Terry Burns said:
OK

Thnks 4 ur reply, but this still does not answer the question. Can u trap
the creation of a new record other than by programatically creating it ?
Click to expand...

Did you investigate the AfterInsert event of your form?
 
Back
Top