Using Access 2000
A new wrinkle has developed.
I have a form called frmCustomers. On this form is a tab page which has fsubProjects, where the bulk of the work is done.
On fsubProjects, there are 2 additional subforms, fsubMaterials and fsubLabour.
In fsubMaterials, there are 3 interdependent combo boxes. The user first selects a Category, then an Item which is dependent upon the Category, then an Item Type which is dependent upon the Item selection. This is followed by quantity and cost per unit.
What is happening is that when I add a new Project, and add the appropriate materials, and click a "Save" button to save the Project, the information that was formerly displayed in the Item and Item Types disappears from view. The data is still there back in the table, but it's disconcerting to have it go away from view.
It have tried
None of these make a difference.