passing values from form to query

[gregd]

I have a form - RunQuery
And I have a query - Q2

The form has text boxes for dates txtStart2, txtEnd2

On button click I have a macro

Query Name Q2
view Datasheet
datamode edit

The query will open



The query has a field Assigned which is Date/Time


In my query design view I have this as the criteria:
>[Forms]![RunQuery]![txtStart2] Or <[Forms]![RunQuery]![txtEnd2]


I also have filter on load set to yes.



However the filter does not seem to work.

Any ideas what is missing or wrong?
thanks

[pbaldy]

What does "does not seem to work" mean exactly? Is the data type of the field in the table date/time? Are the textboxes formatted with a date format? What you have looks like it should work, so I'm trying to figure out why it doesn't. Oh, and are you using a US date format when you enter dates on the form? It should work either way, but it's an area to look at.

[gregd]

Thanks for the response.
I should have specified that my query does not get filtered with the results.


Here are some shots.
You can see my timeframe starts at 3-16-2013. But the result is 3-15-2013
You can also see the formula. I changed the vars to txtStart and txtEnd


https://www.accessforums.net/album.p...chmentid=12180

https://www.accessforums.net/album.p...chmentid=12181

https://www.accessforums.net/album.p...chmentid=12182

[pbaldy]

I'm a dork. You want And rather than Or.

[pbaldy]

By the way, if you want to include the dates on the form:

Between [Forms]![RunQuery]![txtStart2] And [Forms]![RunQuery]![txtEnd2]

[gregd]

thanks,
I should have caught the or.
I upped your reputation.
thanks

[pbaldy]

Happy to help. Sadly, I think my reputation is beyond salvaging.