query as recordsource problem

[Carrie]

Hello

I have a users table which contains users and a date (that they left the dept.). I built a query, CurrentUsers, that bring up only those users still in the dept. as of a given date. This query is the recordsource for the users on my form. On the form, I have an unbound date field where I enter a date and I would like for the query to show only those users who were still in the dept. as of that date. When I run just the parameter query itself, supplying the date, it works fine. When I enter a date on the form, the query displays the wrong results. Does anyone know what I'm doing wrong

Much thanks
Carrie

 

[Peter]

Possible error: date criterium in query should be "SELECT username FROM Users WHERE Date > #" & FORMAT ( Textbox.text,"MM-dd-yyyy") & "#;"

 

[TC]

Show us us the text of the query.

TC

Hello,

I have a users table which contains users and a date (that they left the

dept.). I built a query, CurrentUsers, that bring up only those users still
in the dept. as of a given date. This query is the recordsource for the
users on my form. On the form, I have an unbound date field where I enter a
date and I would like for the query to show only those users who were still
in the dept. as of that date. When I run just the parameter query itself,
supplying the date, it works fine. When I enter a date on the form, the
query displays the wrong results. Does anyone know what I'm doing wrong?