<div>
At what point would I close form A
</div>


<div>
you can close form A after the command to open form B<br />
<br />
docmd.openform &quot;B&quot;,openargs:=me.field1 &amp;&nbsp;&quot;|&quot; &amp;&nbsp;me.field2<br />
docmd.close acform, &quot;A&quot;
</div>


you can close form A after the command to open form B

docmd.openform "B",openargs:=me.field1 & "|" & me.field2
docmd.close acform, "A"

<div>
I don't want to be a bother, but can you tell me how this works? &nbsp;Never used this before and don't know now the &quot;|&quot; works or the usage of it?
</div>


I don't want to be a bother, but can you tell me how this works?  Never used this before and don't know now the "|" works or the usage of it?

<div>
This is awesome! &nbsp;thanks so much!
</div>


<div>
&quot;|&quot; is just a separator for the two fields. it can be &quot;:&quot;, &quot;;&quot; &nbsp;etc..
</div>


"|" is just a separator for the two fields. it can be ":", ";"  etc..

<div>
<div class="content wysiwyg-content">
Hello, <br />
<br />
Is there a way to save an unbound form data, close that form, open the new form and put that data into the proper fields.<br />
<br />
It contains two fields currently<br />
<br />
Don't know even where to start. &nbsp; Dont want to hide the form but load it in memory? Or save it via VBA and put it in the form that way?
</div>
</div>


Hello, 

Is there a way to save an unbound form data, close that form, open the new form and put that data into the proper fields.

It contains two fields currently

Don't know even where to start.   Dont want to hide the form but load it in memory? Or save it via VBA and put it in the form that way?

use data from one form to use in another

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.