Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

I have been using two Combo Boxes. How do I populate the second one with values corresponding to the first ComboBox?

April 26, 2017boxes Combo combobox populate values

0

Posted

I have been using two Combo Boxes. How do I populate the second one with values corresponding to the first ComboBox?

1 Answer

0

Posted

To do this use the SetComboSource() macro action in the AfterUpdate event of the first ComboBox. Example Set the AfterUpdate event of the first ComboBox to: SetComboSource( &secondCombo, “SELECT table2.field1 FROM table2 WHERE table2.field2=&firstCombo” ) This will automatically update the second ComboBox whenever you select an item from the first ComboBox.