Changing From One Form to Another

  • Thread starter Thread starter Tee See
  • Start date Start date
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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

.NET Design Advice - best way to navigate between WinForms? 3
Getting property settings for controls in the immidiate window in VB2005 1
Need help on how to pass calculated field from a form to another form 0
How to programmatically build full reference to a control 2
Access Access Report Works on One Machine but not Another 3
Re: Pass field value selected in Combo Box to SQL Query 1
subforms: using input from one subform to update the other subform 2
Form & Table Design help 2

Back
Top