I posted this in the 'Forms' area but wasn't able to get any significant help.
I put a checkbox on a form. The form simply has buttons to navigate to other forms. I would like the checkbox to reflect a value in a table and for me to be able to change that value and have it update in the table.
When I created the checkbox control, I put the recordsource property to point to the table and field, like this:
=[tblBasicInfo].[CheckBox]
I also put the default value for the checkbox as
=DLookUp("CheckBox","tblBasicInfo"
The problem is that the checkbox is locked. It reflects the value in the table, but I can't change it. If I remove the information from the recordsource property it will allow me to change the value of the checkbox and it will have the value in the table as the default when the form opens, but I can't SAVE the value back to the table.
How can I get this to work? I have looked at all the properties and don't see anything that would be stopping this action.
Please help. Thanks in advance!
Onwards,
Q-
I put a checkbox on a form. The form simply has buttons to navigate to other forms. I would like the checkbox to reflect a value in a table and for me to be able to change that value and have it update in the table.
When I created the checkbox control, I put the recordsource property to point to the table and field, like this:
=[tblBasicInfo].[CheckBox]
I also put the default value for the checkbox as
=DLookUp("CheckBox","tblBasicInfo"
The problem is that the checkbox is locked. It reflects the value in the table, but I can't change it. If I remove the information from the recordsource property it will allow me to change the value of the checkbox and it will have the value in the table as the default when the form opens, but I can't SAVE the value back to the table.
How can I get this to work? I have looked at all the properties and don't see anything that would be stopping this action.
Please help. Thanks in advance!
Onwards,
Q-