pass parameter in forms

  • Thread starter Thread starter mike
  • Start date Start date
M

mike

Hi ALL,

I just want to know how to pass a parameter from one form
to another form. What I mean is that, on one of the form
I created a list box. This list box contains the selected
records from table. When I double click on the selected
record in the list box, the selected record is pass onto
the other form. The other form should take the parameter
and displays the particular record base on the parameter.
How do I do this???

Thanks for the help...

mike
 
Use the Filter argument of the DoCmd.OpenForm action:

DoCmd.OpenForm "SecondFormName", , , "[FieldName] = " & _
Me.ListBoxName.Value
 
Back
Top