frm10 has a text field wherein the user enters DateReceived. VBA code sets the global variable glbDateReceived to that value entered by the user when closing frm10 and opening frm20.
frm20 is a form bound to a table. frm20 is configured so that the user can add new records to the table.
I need a way to programatically set frm20's DateReceived field to the glbDateReceived value each time a new record is created. Occasionally a new record will have a different DateReceived than most of the records being entered and user will need to change it.
What event will fire when a new record is created? My thought is to use that event to do Me.DateReceived = glbDateReceived.
What event am I looking for? Is there a better way to accomplish my objective? Thanks.