Multi-Select List box AND Date Parameters

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.
 
T

This Guy

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top