Multi-Select List box AND Date Parameters

  • Thread starter Thread starter This Guy
  • Start date Start date
T

This Guy

Here is what I am trying to accomplish and I need some help with the code:

I have a form, frmExpirationDateReport. I have two date text boxes,
txtDateBegin and txtDateEnd. I have one multi-select list box,
lstMSAStatusID. From this form I would like to be able to have two command
buttons. One that runs a query based on the date and list parameters and one
that runs a report, rptExpirationDateReport also based on the date and list
parameters.

As of now I can get it to use the list box parameters OR the date
parameters, but when I try to combine them I cannot seem to get it right.

Can someone please help me with the code to do this?

Thanks.
 
Ok I got it. All I had to do was add the date parameters to the query like
normal. I was making it harder than it really is.

I'm having trouble viewing posts on here, from time to time it will just say
Community Messages Unavailable. Is it just me?
 
Back
Top