I designed an application using Access ’97. In the program there is a form that contains a sub form. The details section of the main form has a combo box that is synchronized with another combo box on the sub form.
The main form combo box filterscategories of information and loads the values of those categories in the second combo box on the sub form. Users than select required values from that box and they are stored in a table.
The record source for the main form is a query linked to 2tables. The record source for the sub form is a second query which is also linked to 2 tables.
Sometimes, when users select a category from the main form box and then try to display the values in the second box, they get an error message. The error message stated that the computer can’t find a table or query with a specific name. However the named object is the sub form and not a table or query.
When users close out the form and reopen it, the filter works OK and no error message appears. Again, this problem happens only sometimes.
The standard references for Access ’97 explain how to synchronize two combo boxes on a main form (put one in the header and the other in the details section). However my design is different: one combobox is in the details section of a main form and the other is in a sub form linked to the main form by the same ID number.
Does anyone have any ideas why the error is occurring and how it can be fixed?
