UpDate Query Agrrrrrrrrrrr

[brucey54]

Hi folks, why is this update query not working, I'm trying to update a date field stored in a table.

The new date is passed from a txtbox on a form to the update query!!!

SQL code


UPDATE TblDietPlantemp SET TblDietPlantemp.MealDate = [Forms]![FrmSwitchBoard]![txtCusDate];

 

[CJ_London]

You need to clarify 'not working' - do you get an error message - if so, what? Or does it do something unexpected - if so, what?. Or does it do nothing at all?

It looks like you are trying to update all records with a date on your form - is this correct?

 

[brucey54]

Hi, yep trying to update all records with the same date, the query works ok but doesn’t add the new date field, its blank. I have managed to solve this issue by creating a table first then append the data from the table.

 

[JHB]

After you put in the date in the textbox, did you move focus to another control on the form, (else it would be blank because the control isn't updated yet)?