I have 32 forms, each with the same query format except for the criteria in the LName field. To put this in a different (and hopefully easier way) Form A has a command button that opens form AA. Form AA is based on a query that has criteria set for LName, ie, it will select records based on LName that appear in Form A. Form B has a similar command button and opens form BB that retrieves data from the same table as Form AA. Form AA and BB are exactly the same except for their names and the query criteria. What I would like to know is how do I set the criteria in the query so that I can use the one form(eg AA) to work with all the others(eg A,B,C...etc.) Forms A,B,C..etc all have different names but all have the fields LName and LName on them. I am trying to reduce the size of this database but unfortunately I am not comfortable with Visual basic.

[This message has been edited by GregAust (edited 10-26-2000).]

Are you saying you have 32 forms and 32 queries, or 32 forms and 1 query as the record source of these forms?
You set the criteria to Last Name. Does that mean you have 1 form for each person?
1 suggestion would be to make a Criteria form that lists out all the Names, then set your query criteria = your selection on form. Make a cmd button on this form to open your other form.