i have a macro which runs a query.
the query has criteria [membership number]
i'm planning to run this macro, from forms, through a command button.
is there anyway i can get the macro to get the membership number from the form, automatically and use it to run the query?

thanks.

You would be better off modifying your query slightly. Open your query in design view go to the membership number column in the query. Right click in the criteria cell in the query builder grid and select the build button. Now find the form in the list, find the control that contains the membership number double click on it and it will pop up into the upper window. Now the query will return only records related to the membership number of the form. The form must be open with a number present for the query to work.