cascading combo box

[Guest]

I have made two combo boxes where the selection on 1st combo box is based on
the second combo box. I want the second combo box to populate text boxes in
my Form as I can do this when creating a combo box using the wizard.

 

[Guest]

Kirt,

If you mean that the text fields that will populate the text boxes are other
columns in your second combo box, use the combo box' Column property to set
the ControlSource of the textbox:

=YourComboBox.Column(x), where x is the column number, starting with 0.

Another way to populate the textboxes is to include these fields in the
query underlying the form. Then when the 2nd combo box selection identifies
the primary key, the other field values are determined.

Sprinks