I have an order entry database with two forms. One is for new orders
the other is to update orders. The forms are identical except that one
is strictly order entry. On both forms are three sets of sychronized
combo boxes. When entering test data everything worked perfectly. I
recently migrated 5,000+ records from an Excel file to the database.
The migration was successful and all records were copied over. When I
checked the underlying table, all information was as it should be. But,
when I go to the update order form, on two of the dependent combo boxes
only some of the items are showing. For example, one set of combo boxes
is for order type and features. If the order type is "disconnect" then
its assocated feature correctly appears, if the order type is "change,"
it does not, although the data is in the underlying table. If I prnt
out a record, everything prints correctly and all missing data is
there. Does anyone have any idea why the dependent combo box options
are not always appearing?