Can anyone tell me what needs to be added into this to work please?
Table wanting to update is worker, the field within worker is applicant. It finds it but the where claus of the sql isnt working.
I want to find the record where worker.name field = a field on a form called wdetails (the field is called name)
DoCmd.RunSQL "update worker " & _
"Set worker.applicant = true " & _
"WHERE worker.name= form_wdetails.name;"
the table behind the form wdetails is maindetails
If you need any more info please ask!
Thank you
Table wanting to update is worker, the field within worker is applicant. It finds it but the where claus of the sql isnt working.
I want to find the record where worker.name field = a field on a form called wdetails (the field is called name)
DoCmd.RunSQL "update worker " & _
"Set worker.applicant = true " & _
"WHERE worker.name= form_wdetails.name;"
the table behind the form wdetails is maindetails
If you need any more info please ask!
Thank you