Bill Doherty
asked on
Print Report based on Current Record
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
thanks
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
thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
TheReportFieldThatCorrespo
I never placed the ResNum or ID field onto the report!
thanks for the help