Date Query using Forms Parameter

T

Thorson

I have a query set up to use the date parameter entered into a form. I would
like the query to be limited to the date or before that is entered on the
form. The critera I have in the query is:
<=([Forms]![frmCurrentInventoryDateQuery]![cboDate])

"frmCurrentInventoryDateQuery" is the form used to enter the parameter by
the user, "cboDate" is the control box the date is typed into on the form.
The query returns all records instead of limiting it by the date.

Any suggestions?
Thanks
 
T

Thorson

I tried it again and it is actually working now, the query returns the
correct records, I don't know what I was doing wrong the first time.
 

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