THIS IS DRIVING ME NUTS!!!
Three tables; The first is the parent of the second, the second is a parent of the third. Both relationships are one-to-zero-to many. The relationships are established in the database container.
The form has three combolists. The first uses Table1 as a record source, the second Table2, and the third Table3. There are two additional textboxes that are bound to additional fields in Table3.
In the dataenvironmet of the form, the child tables have a filter set to the parent key, so that the child tables will only show the records that match the parent.
I can select a record from Table1, and the correct information from tables 2 and 3 show up. I can select the second matching record from Table2, and the correct information from Table3 shows up. I can even then select the second matching record from Table3 and the two textboxes contain the correct data.....
BUT -
If I
back around the form, the info in the text boxes ALWAYS becomes the info from the first matching record in Table3. I "watch" the record number in 3, and at some point the record pointer is returning to the top. The ComboList still has the correct information from Table3. Try it.
Clues?
