How to print a report based on a combo box value

AUdby

Registered User.
Local time
Today, 23:42
Joined
Jun 19, 2000
Messages
11
Hi, folks. I'm trying to print a report for a single job classification and its associated data. I'd like the user to be able to select the appropriate job in a combo box, then hit the command button to print the report. I've tried DoCmd.ApplyFilter and DoCmd.OpenReport stDocName, acPreview, , "jobNumber = "&"[cboJubNumber]" but I'm not getting any decent results. Any ideas?

Thanks,
Andreas
 
Have you tried:
"jobNumber = forms!yourform!cboJubNumber"?
 

Users who are viewing this thread

Back
Top Bottom