Quick Answer? Print one record of a report based on dialog box filter

[dcorleto]

Have a report named "Workorder" setup from a Query. The total number of records is about 30. I would like to have the following happen...

From the switchboard have an option to generate a workorder. A Dialog box would open requesting the "Code" (that is, one of the fields that has a unique record entry) and then have just that one page of the report come up and be able to print just that page for the record that the user inputs as the code.
Is there a quick way to go about this? Many thanks in advance.

 

[Remou]

If the code field is text:
[tt]DoCmd.OpenReport "rptReport", acViewPreview, , "Code='" & Me.txtCode & "'"[/tt]
If it is numeric:
If the code field is text:
[tt]DoCmd.OpenReport "rptReport", acViewPreview, , "Code=" & Me.txtCode[/tt]

Where txtCode is the name of the control on the dialog form.