Use Text Box Date in Update Query

  • Thread starter Thread starter GeneR
  • Start date Start date
G

GeneR

I need to use an update query to update all the records
in my table that have no "EndDate" with whatever I enter
in a date text box on my form. I know that the Criteria
in my update query is "Is Null", but what is the syntax
for the Update To line which will capture the date I've
entered in my text box?!

Thank You!!!
 
UpdateTo: [Forms]![FormName]![TextBoxName]
Criteria: Is Null

Hope this helps!

Howard Brody
 
Back
Top