Retrieving matching records in a database

I am trying to have a search form feed criteria to a query which is the
basis for a list box in a search matches form. I cant seem to get the
variables to transfer from the search form to the matches form. the
variables were declared as public. any ideas?

tucker95112@gmail.com wrote:[color=blue]
> I am trying to have a search form feed criteria to a query which is the
> basis for a list box in a search matches form. I cant seem to get the
> variables to transfer from the search form to the matches form. the
> variables were declared as public. any ideas?
>[/color]

queries cannot see vba variables, you can however do either of 2 things:

1. Write a function to return a variable's value or
2. Reference a control on a form, e.g. forms!myform!mytextbox