I just got finished creating a search form that will search all of my records the way I want. The end result is a query, depending on the type of search. So, when the user clicks on the OK button of the search form, one of five queries is executed depending on what fields have been used to enter criteria.

At this point, I need to move on to the next step of opening a form with the data that the query generated. Unfortunalty, this form does not have all the fields from the query, but one list box. I want the information displayed in rows in the list box. (This is so that the user can double-click on a certain record to edit it. )

I can do this part, but what I don't understand is how to open the same form and use different queries for the list box, depending on which one was executed in the previous form.

Is there a way I can code the OK button on the previous form to open the 2nd form but use the OpenArgs? Other than that, I can't think of what to do.

TIA

Dustin

Sounds to me like you are on the right track. Just send a variable to the 2nd form using the OpenArgs argument in Command button on the 1st form and then set the Row Source for your list box to the appropriate query based on the variable passed.

HTH,
Jack