Cascading combo box question

[ittechguy]

I have a few cascading combo boxes.



They work like you'd expect them to, the first one contains organizations. After I select an organization, cboShopName and cboOfficeSym requeries and values are displayed in both combo boxes.

I'm wondering, is it possible for cboShopName and cboOfficeSym to be unfiltered until an organization has been selected?

Currently both combo boxes contain no values until after an organization has been selected. I'm trying to make it unfiltered because a user might not know the organization name, but they do know the shop name.

[ItsMe]

Don't include the WHERE clauses of the combos' rowsources when the form first opens.

[ittechguy]

Thanks for the reply. I'll give that a try!