fitzgeraldrl25
New member
- Local time
- Today, 05:14
- Joined
- Sep 13, 2019
- Messages
- 3
What I am trying to accomplish is update multiple records in a table that meets criteria that is stored in a combobox. The field that I am trying to update set to Null (also a combobox stored as text, key field hiding).
I have been able to get the where statement working with a checkbox
Code that I have tried (code works without WHERE statement
I have been able to get the where statement working with a checkbox
Code that I have tried (code works without WHERE statement
Code:
CurrentDb.Execute "UPDATE [Main] SET [TAD]= Null" & "WHERE [TAD] = Me.TADSlctRtrn.Value"
CurrentDb.Execute "UPDATE [Main] SET [TAD]= Null" & "WHERE [TAD] = Me.TADSlctRtrn.text"
CurrentDb.Execute "UPDATE Main SET TAD = Null" & "WHERE TAD = Me.TADSlctRtrn.Value"