Why won't my query work?

  • Thread starter Thread starter Jeffrey K. Ries
  • Start date Start date
J

Jeffrey K. Ries

I have a form where I am trying to filter a subform to display only info
from a specific day and only from the current user.

I tried to do this through a query but it only works with the userID, when I
add the criteria for the date I get zero results.

Could this be an issue of formatting or something else I am just missing?

Jeffrey K. Ries
 
I have played with this a bit more and I have more info.

If I run the query alone and it promts me for the inputs the query works
fine.

If I run the main form where the query is embedded not only does it not work
but the date field I am attemting to draw from is gone. This is in the form
of a text box. The text box is automatically filled by an event built into
the OnOpen property. This works fine unless the query is included.

Jeffrey K. Ries
 
Back
Top