Okay, I'm still learning and a bit confused how to make this work. I have a Yes/No unbound field on my form. When the user checks the box, I need a field in a table to change. The form is bound to Table1, but I need "Status" field in Table2 to update. How do I write this? Help!
Checkbox = True changes field in another table
- Thread starter hbrehmer
- Start date
- Local time
- Today, 07:53
- Joined
- Aug 30, 2003
- Messages
- 36,254
Thank you for this code, but that won't do what I need. The unbound check box should update a field for the same record in a different table. They are linked, so this should be easy, right?
- Local time
- Today, 07:53
- Joined
- Aug 30, 2003
- Messages
- 36,254
Sorry, read too fast. Presuming the form can't be bound to a query that includes both, you can update it with SQL:
CurrentDb.Execute "UPDATE Table2 SET Status = 1 WHERE KeyField = " & Me.KeyField
If the status value is text it would need to be surrounded by single quotes.
CurrentDb.Execute "UPDATE Table2 SET Status = 1 WHERE KeyField = " & Me.KeyField
If the status value is text it would need to be surrounded by single quotes.
I just want to confirm, this code will update only the record based on the the current record in my form? I don't want to change all the records in the 2nd table, just the one that is linked by the same ID number.
- Local time
- Today, 07:53
- Joined
- Aug 30, 2003
- Messages
- 36,254
Yes, the WHERE clause should handle that, and Me.KeyField should pull the ID from the record you're on in the first form. Obviously you have to use the name of the control on your form that has that value.
