Hi to all, I have an interesting problem that I hope is solvable, however I could be asking the impossible.

I have a query in my project that retrieves all needed data from three tables to generate a Work Order Report. Right now the query is hard coded for a single Work Order i.e. WHERE WorkOrder.JobNo = 'Job1'. If I want to make a report of another Work Order I have to change the hard coded search parameter, not very flexible. I can set up the query to ask for a work order number i.e. WHERE WorkOrder.JobNo = [Job Number]. When run the query pops up a dialog box asking for a Job Number. What I want to do is have a button on the Work Order form that passes the work order number to the query then displays the report. I need to pass to the query what is in the Work Order form's JobNo text box.

So I guess the question is how can the information in a form's text box be passed to a query that is the basis of a report?

Thanks in advance, Mike Girard.

Modify the command button text to be something like this:

'If JobNo is numeric...
DoCmd.OpenReport "rptMyReport", , , "[JobNo] = " & Me!txtJobNo

'If JobNo is alpha...
DoCmd.OpenReport "rptMyReport", , , "[JobNo] = """ & Me!txtJobNo & """"

...where Me!txtJobNo is the textbox that contains the job number in question.

This kind of question (unrelated to the book) should be directed to the appropriate forum. I suggest posting such future questions to the Microsoft product-specific newsgroups. See the following page for instructions on how to connect to the Microsoft newsgroups.

http://www.pacificdb.com.au/MVP/newsgroup.htm

Graham R Seach
Microsoft Access MVP