Changing From One Form to Another

T

Tee See

I have a Combo box on frmMyForm1 and a subform which displays the results of
the lookup based on the Combo box.
I would like to Double Click on one field of the output crlItemCode, close
frmMyForm1, open frmMyForm2 and have it display the info about the itemCode
that was double clicked. Then, once finished with that information have a
button that would take me back to frmMyForm1 again.
Any ideas or references would be appreciated.
 
A

Al Camp

Tee See,
Use the Dbl-Click event of ItemCode to open the other form. Use the
value in ItemCode in the Where argument of the OpenForm method.

This is a sample, use your own names...
DoCmd.OpenForm "frmSecondForm", , , "ItemCode =
Forms![frmFirstForm]![frmFirstFormSub.Form![ItemCode]"

Leave the first form open when the second opens. When you close the
second form, you'll return back to the first form automatically.
 
Top