Hello.
On a form I have 2 combo boxes (the first controls the values of the second) and a subform with a combo box on that form.
When selecting values using these combo boxes, all seems to work fine, however when I return to the first record and then move through each record in turn, the values in the 2nd combo box (dependant on the first) and the 3rd (on the subform, also dependant on the first) do not appear.
If I click on the combo box then the correct value is displayed. i.e. the values I originally choose have been stored correctly but are not displayed.
Does anyone have any ideas, as this is driving me 'round the bend ?
If it helps, I can attached the DB.
Thanks
J.
On a form I have 2 combo boxes (the first controls the values of the second) and a subform with a combo box on that form.
When selecting values using these combo boxes, all seems to work fine, however when I return to the first record and then move through each record in turn, the values in the 2nd combo box (dependant on the first) and the 3rd (on the subform, also dependant on the first) do not appear.
If I click on the combo box then the correct value is displayed. i.e. the values I originally choose have been stored correctly but are not displayed.
Does anyone have any ideas, as this is driving me 'round the bend ?
If it helps, I can attached the DB.
Thanks
J.