<div>
There are several solutions. &nbsp;Here's two.<br />
<br />
1. Before opening the pop up form, store the date in a memory variable. &nbsp;That way the pop up form gets the date from a memory variable and doesn't care what form put it there.<br />
2. Use the open args argument of the OpenForm Method to pass in the date.
</div>


There are several solutions.  Here's two.

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.

<div>
<div class="content wysiwyg-content">
I have a form that can be opened via a command button from four other forms. &nbsp;When the 2nd form opens I want a date field to automatically populate from a date field that is in the 1st form.<br />
<br />
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, &nbsp;Somehow the 2nd form has to know which of the 4 forms is open and use the date field from that form.<br />
<br />
????<br />
<br />
--Steve
</div>
</div>


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.

????

--Steve

How have field on a form auto-populate with a data field from another form

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.