Updating my Combo Options

[andysgirl8800]

I just added a column to my table upon which a cascading combo box is built. When a name is selected from the combo box, 2 related fields populate. I want it now to populate a 3rd field. So I added the column to the table to input the data into that 3rd field, and adjusted the column widths and count in the combo box. However, when I indicate the control source of the 3rd field as the corresponding new column from the combo box, nothing populates in my 3rd field. I've tested it by designating one of the previuosly exisiting combo box columns and it will populate the data, but it seems to not be recognising my new column. I've also verified the properties of the new field to ensure that it is visible. What went wrong?

 

[llkhoutx]

You also have to update the combo box's Column Count and Column Width Properties.

Column Count should now be 3.
Add a 0 width to the Column width; this hides the added column.

 

[andysgirl8800]

Thank you for your response. I've verified that the column count for the cascading combo are accurately adjusted, and that I've included the ;0" to hide it from the drop down, but I still can't see it in the text box. I can't figure out if it's a problem with the text box or the combo box. The combo seems fine, but I'm not sure what could be wrong with the text box. Still struggling....

 

[llkhoutx]

You don't describe how your populating the text boxes.

Remember, combobox columns are numbered 0,1,2,3 . . .

Therefore, picking up column 3 would be, on the combobox AfterUpdate event,

me!YourTextBox = me!YourComboBox.column(2)