criteria and reports and forms 1

[goodwork]

I have a problem.

I can make querys very easily. I can make reports very easily based on the query.

I now have a problem, I need to make a report based on a criteria on a query. However, this criteria changes all the time. Does anyone has a way, of entering a criteria on a form, in a text box, and then the correct report can be previewed by a preview command button?

Thank you very much

 

[chrissie1]

put this in the criteria of the query

=forms![formname].form![textboxname]

Christiaan Baes
Belgium
"What a wonderfull world" - Louis armstrong

 

[goodwork]

Cool! Thanks - it works!

Thanks a lot