Using current form data in report selection query 2

[KarenMO]

Hello - I have created a very simple (flat) database that has just four user fields and some command buttons for viewing and printing reports. The users will only ever need to print these small summary reports based on the job number of the current record in the form. The report is based on a query that, if run from the report tab, will prompt the user for the job number. I would like the user to be able to view or print the report from the (command button on the) form without having to enter the selection criteria, because the job number will already be displayed on the form. I have done this successful in a previous database and have tried to duplicate the coding scenario in that database, but without success. Thanks in advance for any help! - Karen

 

[mp9]

In the query criteria, instead of having the job nunber criteria equal to a prompt, set it to something like:

=[Forms]![YourFormNameHere].[YourJobNumberFieldNameHere]

Then when the query runs it will pick the currently displayed job number up right off the form.

http://www22.brinkster.com/accessory/

 

[THWatson]

Karen
You can include a WHERE clause in the DoCmd line that opens the report.

For example...
DoCmd.OpenReport "YourReportName", acViewPreview, , "[JobNumber] = '" & Forms!YourFormName!YourFormField & "'"

Tom

 

[KarenMO]

WOW, mp9 and Tom - that was SUPERFAST - the "ink" has barely dried on my post! Both solutions are useful and this is all I need to finish up the database and send it to the client. THANKS SO MUCH! - Karen