Combo Box providing 2 different selections

[331]

Hi all,

2 buttons on the Main Menu each open the same Customer screen with same tabs and forms/subforms. Button 1 filters to 400+ New and Continuing Customers, button 2 filters to All 6000+ Customers including potential ones.

When the Customer screen opens, the same combo box appears which works fine. I've set its Row Source to offer all 6000+ customers as a selection option. However, when filtering to new and continuing customers, all 6000+ customer names appear in the combo box. Is there a way that I can limit the names in the combo box to only the 400+ New and Continuing Customers when button 1 is selected, without limiting that selection when the screen opens for all 6000+ Customers -- since this is the same screen with filtered customer data?

Aside from this, everything else works fine. Many thanks!

 

[ajetrumpet]

I've set its Row Source to offer all 6000+ customers as a selection option. However, when filtering to new and continuing customers, all 6000+ customer names appear in the combo box.

There is no way to tell what you are doing here unless you provide some SQL statements, or snapshots, or a database file.

Is there a way that I can limit the names in the combo box to only the 400+ New and Continuing Customers when button 1 is selected, without limiting that selection when the screen opens for all 6000+ Customers -- since this is the same screen with filtered customer data?

Yes. I would do it with conditionals and two different SQL statements attached to the two buttons.