I know this quesion has been asked a million times but.....

the answers that I have found havne't worked.
It's simple. I have query that has a date field. I have a form with two
unbound tex boxes, one called txtstartdate and txtenddate.

I also have other text boxes that work. One allows you to enter a location,
and the other allows you to enter a customer. They are and/or. You don't need
one to search by the other, but you can search by both if you want to.

The code for the startdate and enddate txt boxes is:
Between Forms!QBF_Form!txtStartDate and Forms!QBF_Form!txtEndDate

It does not filter for a date. What am I doing wrong.
.

Relevant Pages

  • Re: Filtering records on a form using multiple combo boxes
    ... The goal is to make a valid query statement. ... You can also ask Access to print the string to the Immediate window. ... = page the text boxes are on ... filter the field in the record list box.. ...
    (microsoft.public.access.forms)
  • RE: need similar solution to "cascading combos"...
    ... that) as the basis of a query. ... Is there a way in code to access the subform's recordset in a query. ... This will cause Combo2 to filter it's data based on the value in Combo1 ... boxes, I used several unbound combo boxes for Customer Name, Product Name, ...
    (microsoft.public.access.forms)
  • RE: need similar solution to "cascading combos"...
    ... Is there a way in code to access the subform's recordset in a query. ... So let's say that Combo1 has a query that includes CustomerID and ... This will cause Combo2 to filter it's data based on the value in Combo1 ... boxes, I used several unbound combo boxes for Customer Name, Product Name, ...
    (microsoft.public.access.forms)
  • RE: need similar solution to "cascading combos"...
    ... that) as the basis of a query. ... Is there a way in code to access the subform's recordset in a query. ... This will cause Combo2 to filter it's data based on the value in Combo1 ... boxes, I used several unbound combo boxes for Customer Name, Product Name, ...
    (microsoft.public.access.forms)
  • Re: access 2003
    ... the "ChooseJob_AfterUpdate Event" uses this filter ... the form to show a new set of records: For, as you know, the query points to ... the two combo boxes for criteria information. ...
    (microsoft.public.access.conversion)
Loading