Form not holding information visually

[dray]

Hello,


I am new to the site and new to Access...I am using Access 2010 and am having an issue with a form I have created.

I have three combo boxes on a form...selecting the first populates the selection available for the second box....and the selection in the second box auto fills the third box

All of this data, when entered in the form, does populate the table associated, but when you go back through the records on the form the second and third combo boxes are "empty". If I pull the drop down in the first combo box and re-select the the proper value, all of the information in the second and third boxes show back up.

It is also not every record....some of the records keep all of the information and some do as I described above.

If anyone could give me some guidance I would be very appreciative

[June7]

Presume you are using multi-column comboboxes with lookup.

Is the form in Single, Continuous, or Datasheet view?

If you are navigating records, need to requery the dependent comboboxes when each record gets focus. So in the form Current event:
Me.comboboxname2.Requery
Me.comboboxname3.Requery

However, multi-column comboboxes with lookup won't work nice in Continuous or Datasheet view, not even with the above code fix.

[dray]

The form is single view and your code worked perfectly! thank you very much!