Access_Help
Registered User.
- Local time
- Yesterday, 19:59
- Joined
- Feb 12, 2005
- Messages
- 136
I require the report to open using two conditions (one condition using a listbox and the other from a drop down). I am getting a data mismatch error:
Combo12 holds a date.
Code:
DoCmd.OpenReport vRpt, acPreview, , "[Name]= '" & lstEAddrs.Column(1) & "'" And "[WeekEnding] = '" & Combo12 & "'"
Combo12 holds a date.