From a click event I want to set the value in a table
I get an error with this;
tblNavigation.Toggle_condition = False
From a click event I want to set the value in a table
I get an error with this;
tblNavigation.Toggle_condition = False
You can't do it that way. Normally the form would be bound to the table, and you'd just set the form control that holds that field. Failing that, you're looking at running an update query or using the update method of a recordset.
the text box is bound to the field
txtBox = tblNavButton.value
You cant do something like this?
Set rec = CurrentDb().OpenRecordset("tblNavigator")
rec("Toggle_Condition") = False
That's...kind of...the recordset method I mentioned...with errors. What you have would change the first record in the table, not necessarily the record displayed on the form.
Thanks for the help