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

[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

 

[John Vinson]

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.

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!

 

[Terry Burns]

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

 

[Rick Brandt]

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 ?

Did you investigate the AfterInsert event of your form?

 

[Terry Burns]

ok, thats what i'm looking 4.

Regards

Did you investigate the AfterInsert event of your form?