B
brendan
Guest
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.
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.