MS Access SQL Where statement based on Combobox value

[brian_msbc]

 SELECT DISTINCT NetworkManager
 FROM MasterProfileSummary
 WHERE Region = [Forms]![formQuestHist]![comboRegion]

If the combobox "comboRegion" is null, then I want to include all regions, else I want to filter for the region specified in the combobox. How should this Where statement be altered?

 

[jdraw]

See this post re combobox.

 

[pbaldy]

Or

http://access.mvps.org/access/queries/qry0001.htm

 

[brian_msbc]

This worked successfully. However, if I change Combobox A's value, and Combobox B has a where statement dependant on Combobox A, why doesn't Combobox B automatically update when the Combobox A changes? How can I achieve this goal?

 

[pbaldy]

You'd need to requery combo B in combo A's after update event.

 

[brian_msbc]

awesome. Thanks

 

[pbaldy]

Happy to help!