I often use forms to select a parameter & date range for a subsequent report. Where I have chosen to use multiple combo boxes (two in this case)to select more than one parameter I have run into a problem. The report opens ok the first time but if I close it (report) and change my selection then the report refuses to open. Should I just requery the two combo boxes, is there something else or can't it be fixed?
Multiple Parameters
- Thread starter AN60
- Start date
klwu
Brainy!!
- Local time
- Tomorrow, 05:34
- Joined
- Sep 13, 2004
- Messages
- 47
how you link the criteria to the report??
using DoCmd??
I don't know about others, but what I will do is, I will set the parameters of the report to read from the combo boxes......and then use DoCmd to open the report with the parameter......like this:
using DoCmd??
I don't know about others, but what I will do is, I will set the parameters of the report to read from the combo boxes......and then use DoCmd to open the report with the parameter......like this:
Code:
Dim stLinkCriteria As String
Dim stDocName As String
stLinkCriteria = "[someDate]=" & "'" & Me![cmbDate] & "'"
DoCmd.OpenReport "someReport", , , stLinkCriteria