I need to generate an initialisation record in a table when I click Add Record in a form based on a different table.

The form creates a New Client record (Name, Address, etc.) in the Client table. I have a Timelog table which is used to log online hours and dates. This gets its data from a Timelog subform, but when a new client is selected, the subform comes up empty as there is no initialisation record.

My idea was to create a record in the Timelog table as part of the OnClick event when the New Client record is being saved.

Any ideas gratefully accepted.

Have you tried setting the Default Value in the properties for the text fields on the subform?