sending control from one for to another without unloading first form 1

[tyedyejenn]

This is what's happening<br><br>A user is entering in records on frmCustEntry, when they get to a new customer(one not in our database) the user is prompted (via msgbox) to create a record for this account number, when they click yes I have another form that pops up(frmCustName) that the user enters in first and last name.<br>After user enters in the name I want to continue with the code on frmCustEntry<br><br>I don't know how to make the code on frmCustEntry &quot;pause&quot; to allow user to enter info into frmCustName then &quot;restart&quot; after user enters info on frmCustName<br>Any suggestions are greatly appreciated!!!!Thanks--Jenn

 

[catfish]

Try this (modify to your needs):<br><br>reply = MsgBox(&quot;This Pub is not on File; Create it?&quot;, vbExclamation + vbOK, &quot;Warning&quot<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;If reply = vbOK Then<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;frmNewPub.Show (vbModal)<br><br>when you are finished with the new one, do an &quot;Unload Me&quot;,<br>you should be right back where you started from. (JRA)<br>

 

[tyedyejenn]

Thank you catfish--I was missing the vbModal in the show statement--Jenn