Form doesn't recognize legitimate fields

SBullard

Registered User.
Local time
Today, 11:47
Joined
Dec 17, 2011
Messages
13
I have a form attached to a table. When I go to edit the form and try to add fields, there is one particular field that it doesn't recognize. The control is a combo box attached to a form called intShop. It has a value list with 3 items in it and the first column is the data that is saved, it is either 1, 2 or 3. The field is set to Number, Integer in the table.

The field comes up in the field list for the form, but if I run the form, it will not allow the control to be edited, it says that the control is bound to an unknown field.

I have tried deleting the field, renaming the field, creating a new table, every time it does the same thing. I have used the same procedure successfully in other forms/table combos and can't see anything different here. Is there something basic I am missing?
 
...I have tried deleting the field, renaming the field, creating a new table, every time it does the same thing...
Have you tried recreating the Combobox? Perhaps it is corrupted.

Linq ;0)>
 
I might have figured it out?? I created a new database with only the tables and forms that were problematic. The new database works fine. Maybe there is corruption in the database that I am using?

If I create a new database and transfer everything over, maybe that will solve the problem? What do you think.
 
Anyway to keep Access from changing the format when I import all my new forms?
 

Users who are viewing this thread

Back
Top Bottom