I have a form that can be opened via a command button from four other forms. When the 2nd form opens I want a date field to automatically populate from a date field that is in the 1st form.
But since this date field on the 2nd form can be opened from any one of 4 forms, I am not sure how to populate the date field, Somehow the 2nd form has to know which of the 4 forms is open and use the date field from that form.
1. Before opening the pop up form, store the date in a memory variable. That way the pop up form gets the date from a memory variable and doesn't care what form put it there.
2. Use the open args argument of the OpenForm Method to pass in the date.