Help with my Date Query

[yus786]

Trying to run a query that takes the dates from 2 text boxes from another form.

This is the qry

SELECT Attend.AttStudent, Attend.AttType, Attend.AttDate
FROM Attend
WHERE (((Attend.AttDate) Between [form]![termdate]![fromdate] And [form]![termdate]![todate]));

Where the 2 text boxes are fromdate and todate.

However if i run the qry all i get is

What am i doing wrong?

 

[maxmangion]

change [form] to [Forms]

 

[yus786]

change [form] to [Forms]

No joy i'm afraid

 

[maxmangion]

is the form opened with the textboxes populated ?

 

[yus786]

is the form opened with the textboxes populated ?

AH ok - it wasn't

I opened it and voila it worked.

So the form needs to be opened?

 

[maxmangion]

the way you set it up Yes you need to have the values in the textboxes, otherwise you will get the box that you attached, however, if you type your dates there, it still works, although it is less user friendly.

 

[yus786]

the way you set it up Yes you need to have the values in the textboxes, otherwise you will get the box that you attached, however, if you type your dates there, it still works, although it is less user friendly.

Thanks for you help.

I'll think of something to keep the box in the background maybe minimize

 

[maxmangion]

you're welcome.