I have an access 2003 database where the main job is to store equipment info and all repairs to each.
Basically its like this, i have a table/form for computers, printers, telephones, and servers; i have a single table to store repairs for all 4 types and 4 subforms that go with each corresponding form.
My goal is when you cycle through the records in the forms, the repair data for each will show in the subform. Both current and new repair data works just fine. This works with three of the forms but one (computers) does not cooperate.
First current repair information does not show at all for any record, second when adding new repair info in the subform the data will go into the table but when you advance one record and return the subform data is gone. basically the subform will only show 'new record entry' only, not current data.
I have compared every property setting with working forms/subforms and all data is the same/correct.
Im stuck on something im sure is very simple, but it escapes me.