Print Report based on Current Record
Posted on 2011-03-08
I have been trying to print a report based on a current record being displayed in a form.
the form Name is Input, the Report name is Reminder the uigue feild in the table is ID and on the form it is ResNum they are set to have the same value ( I populate ResNum with the value of ID)
For a couple of days I have tried every suggestion I could find in this forum but the results are not what I am looking for. I either get the Input parameter box for ID or I get the report opening only tothe fiirst record or a blank record.
I am using a print button with event procdure as follows (the most recommended to use)
Dim stDocName As String
Dim stWhereCriteria As String
stDocName = "Reminder"
stWhereCriteria = "[tReservations].[ID]=" & Me.ResNum
DoCmd.OpenReport stDocName, acPreview,,stWhereCriteria
What am I doing wrong? I even tried to use the embedded code that was result of butto wizard with where info but nne of it successful