I fear you are going to find that MSQuery works against Fields in Tables in
Databases, not against Forms and Text Boxes, so you'll have to use a
different approach.
--
Larry Linson
Microsoft Office Access MVP
Co-Author, Microsoft Access Small Business Solutions, Wiley 2010
The end goal is the bring in the date in the text box to an Excel
Spreadsheet through Microsoft Query. People go into the form and change the
date to what they want and run reports off of that date. The text box is not
bound because when I bound the text box it no longer defaults to today's
date, which I want it to do. If I could bound the text box and still keep it
defaulting to today's date everytime someone opens the form that would solve
my problem, as I would just pull the bound record. So now the alternative (I
think) is to produce a query that will give me that date so I can send it on
to excel (the report ends up in Excel, just want the as of (text box) date
to go along with it).