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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update Subform Query 3
Using an append query in a subform 1
Textbox in an Update Form 1
Search by date 2
Update Two Tables Using One Form Contents 0
Main Form and two Subforms 2
Access Form - Lock Fields from Editing 0
Using Between criteria to search query 1

Back
Top