How to get Query Criteria to pull the ID of the record automatically when running a report,

[craigperkins]

I have a report that pulls information from a query on my main database a report of booking information, however we have to type in the ID number to pull the report.

Query criteria being [Enter ID Number] which comes up when you hit the report button.



I would like the report to automatically pull the ID number when we hit run report.

Can anyone help?

Below is current Event Command, Thanks

Private Sub Command734_Click()
On Error GoTo Err_Command734_Click

Dim stDocName As String

stDocName = "Confirmation Hotel Email WPD"
DoCmd.OpenReport stDocName, acPreview

Exit_Command734_Click:
Exit Sub

Err_Command734_Click:
MsgBox Err.Description
Resume Exit_Command734_Click

End Sub

[Welshgasman]

Where are you meant to get the ID from?

[craigperkins]

So the ID is a field within the database, our booking number.
I get the feeling I need to put something in the "on Click" and in the query but I am lost.

[Welshgasman]

So the ID is a field within the database, our booking number.
I get the feeling I need to put something in the "on Click" and in the query but I am lost.

Yes, the ID would be a field in the database, that will likely contain many records and hence many values.
How are you intending to identify the one that you want out of all of those records?

[craigperkins]

When you are on that specific record form you then hit the button to run the report.

[Welshgasman]

Ok, then the Where condition would be along the lines of

"ID = " & Me.BookingNumber

where ID is the field name, and BookingNumber the control name.

If the bookingnumber is actually text, then surround that with '

Microsoft always has documentation of it's products, though in this case they only show the filter parameter, not the Where parameter.

https://learn.microsoft.com/en-us/of...cmd.openreport

Plenty of videos also on YouTube on Access

https://www.youtube.com/watch?v=I3AQVZCEHmI

[craigperkins]

Fixes - you are a star....... Thanks a million.