I'm using access 2000 i have a table called sheet2 with multiple columns, one of the columns is "date", I also have a form called shows. In the form I created a I created a button that runs a macro. The macro runs a query. I want to type the criteria for the query in a text box in the form. In the criteria field of the query i have "[Forms]![shows]![Text]"The text box is called text. When i enter search criteria in the text box then click on the button that runs the macro i get a window with a title bar "enter parameter value"under the title bar "forms!shows!text". If i type the date i'm searching for in that box the query works fine. The query works fine if I manually type the search criteria in the criteria field of the query.
i'd be grateful for any help
thanks again
tom

1) Try bracketing your reference to the text field with "#" & ... & "#", or change it to date/time type.
2) Naming a field 'date' can cause all sorts of weird problems, because it is a function/reserved word in access. Choose something more descriptive and see if that helps.

HTH,
David R