IF New then...

[CraigBFG]

Is there any way that I can create a record in another table based on the ID of another, when a new record is created.

Eg
Create a new employee record
Insert this new records ID into tblTraining.

I could use a button. Is it possible to say "show button only if form is DataEntry/New Record"?

Thanks
Craig

 

[dcx693]

This is possible, but why do you want to do this?

FYI: You can use the Me.NewRecord property to check if the current record is a new record.