Need help on criteria syntax related to

I am trying to build a query using a criteria that references a value in a
textbox on a form. The value in the textbox will follow the format yyyymmdd.
If I replace the below code for the criteria with the value <="20050331", the
query returns the correct records, but if I try and use the below code for
the criteria to reference the value from the textbox on the form, I get no
records returned? I have the textbox visible on the form, and see the correct
value populated of 20050331. Syntax issue??? Suggestions?

<=[Forms]![frmConsortium]![TextCutoffDate]
.

Relevant Pages

  • Re: Showing certain record only
    ... In my database I have a toggle button that once pressed ... My Main form is called frmProject which gets it data from a query ... unbound textbox, txtZeros. ... I add the following criteria to the filtering query for the listbox, ...
    (microsoft.public.access.forms)
  • Re: Compile error on common function, NOT REFERENCE PROBLEM
    ... When running the query, I get the immediate ... in criteria expression" message. ... > the references in Tools-->References, check for missing ones, remove ones, ... >>> compile error. ...
    (microsoft.public.access.modulesdaovba)
  • RE: updated numbers in report
    ... criteria for a number of queries. ... But i have one more question, its about a textbox. ... textbox will be located alongside with the combobox where the belonging ... will not make the input to the query. ...
    (microsoft.public.access.dataaccess.pages)
  • RE: updated numbers in report
    ... it is looking as you have described, when using only the criteria from the ... for the input in the query it is not. ... i was thinking this, that the combobox ... have a list from the table, and the textbox have not. ...
    (microsoft.public.access.dataaccess.pages)
  • RE: trying to capture numbers in a text box
    ... that every textbox on the form is one of your order number input boxes. ... For Each ctl in Me.Controls ... If you're using a command button to execute the query, ... Then, in your query, set the Criteria to be equal to the hidden textbox ...
    (microsoft.public.access.forms)