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
