pass parameter in forms

[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

 

[Ken Snell]

Use the Filter argument of the DoCmd.OpenForm action:

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