Print out single record onto a report

[CQCDave]

I have a form NoWorkOrder, i have attached a command button to Print Report. The report is named No Work Order. When i'm viewing that a record in Form View and click the command button i want only that record to print out onto the report.
I'm using Ms Access 2010. Thanks for the assistance.

[cbende2]

So what's your problem, you're not too clear?

Are all your records printing out, are no records printing out, is anything happening unusual?

[CQCDave]

Yes, sorry Now all records print out when i click the Run Reports button.

[John_G]

You use the Criteria parameter in the DoCmd.OpenReport command.

DoCmd.OpenReport "No Work Order", acViewNormal, , WhereCondition

where WhereCondition is a string that uniquely identifies the record you want to print. It looks like a SQL where clause without the WHERE.

for example: DoCmd.OpenReport "No Work Order", acViewNormal, , "Id = " & me![Record_Number]

[CQCDave]

Still having issues.... This is what i have;

Dim strDocName As String
Dim strWhere As String
strDocName = "NoWorkOrder"
strWhere = "[ID]=" & Me!ID
DoCmd.OpenReport strDocName, acPreview, , strWhere

It does prompt me to enter the ID but still prints out both records in the form ( only have 2 in the test database)

Thanks for the help...

[John_G]

It prompts you to enter the ID? It shouldn't, at least not from anything in the code. Is [ID] the right name of the field in the table/query the report is based on (the prompts suggests it is not)?

[CQCDave]

Yes, ID is the correct field.

[June7]

If the report RecordSource is a query, post the SQL statement.

[CQCDave]

I have "On Click" it runs the following;

Dim strDocName As String
Dim strWhere As String
strDocName = "NoWorkOrder"
strWhere = "[ID]=" & Me!ID
DoCmd.OpenReport strDocName, acPreview, , strWhere

[June7]

You already told us that.

Asked for the report RecordSource sql statement.

If you want to provide db for analysis, follow instructions at bottom of my post.

[CQCDave]

Here is a link to the database, Once opened click on Bracketry Data tab, then Open No Work Order Form.

https://app.box.com/s/19kll6hm1abky7sw9ijw

Thanks for your help,let me know if there is anything else you need.

[June7]

Couldn't download. Maybe this weekend I will be able to use faster internet.

Otherwise, reduce file size (make copy and delete records and/or other stuff not relevant to the issue) and attach to post.

[John_G]

Hi -

I got the download. The problem is as I thought - the ID field. Your report NoWorkOrder has a query (SQL) as its recordsource, but that query does not include the ID field from the NoWorkOrder table, and as a result the criteria in the Docmd.Openreport cannot find it and treats it as a parameter.

Add the ID field to the report's recordsource and it should work fine.

[June7]

As I suspected as well, which is why I asked for the SQL statement to be posted for review.

[CQCDave]

That did it, thanks for the help.