I have an MS Access 2007 application running on my Vista Business PC which connects to a SQL Server 2000 database via ODBC. On an Access sub-form I have two CheckBoxes connected to two fields through a select query.
The Sub-form was originally created with only one CheckBox and it worked fine. I added a field to the database called Reimbursable_TF as NVARCHAR 5 with a default value of (0) - this is exactly the same as the first field I created connected to the first CheckBox except its name is different.
When I added the second CheckBox to the sub-form bound to the new field and tested the form I got the 'Control can't be edited; it's bound to unknown field <Reimbursable_TF>. After trying a number of other things including Compact and Repair Database, in desparation I re-named the field in the SQL Server table to 'Reimbursable' and received the error message 'Control can't be edited; it's bound to unknown field <Reimbursable>' - in other words no improvement.
I then tried adding a TextBox to the sub-form bound to 'Reimbursable' but it displays '#Name?' and I get the same error when I attempt to edit the field.
When I open the query for the sub-form I can edit the Reimbursable field in the Recordset and I can see the data is saved when I close the query and re-open it.
What do I have to do to make the Reimursable field editable?