Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
how can I pass selected criteria from a form to a report 1
- Thread starter pthakar
- Start date
FancyPrairie
Programmer
Try using the WhereCondition argument of the OpenReport method.
-
1
- #3
You could try
Dim stDocName As String
stDocName = "Confirmation"
DoCmd.OpenReport stDocName, acPreview, , "stay.stay_id = " & Stay_ID
Stay is the Form, Stay_id is a field on the form.
I used this many years ago it might need a bit of work. But I am sure i have a another thread along similar lines
I only found this site a week ago so it should'nt be to hard to find
Hope this helps
Dim stDocName As String
stDocName = "Confirmation"
DoCmd.OpenReport stDocName, acPreview, , "stay.stay_id = " & Stay_ID
Stay is the Form, Stay_id is a field on the form.
I used this many years ago it might need a bit of work. But I am sure i have a another thread along similar lines
I only found this site a week ago so it should'nt be to hard to find
Hope this helps
- Status
Similar threads
- Locked
- Question
