Filter by Combo Box

[sdebo2]

I would like to filter my form based on the value in a combo box. I have a apply filter macro, with the where condition is Forms![CronStore]![Location] = Forms![CronStore]![FilterLocation], and set it to run after update on the combo box. But when the filter is applied there are no records shown. Any assistance would be greatly appreciated.

 

[mark curtis]

If the form is built on a query then in the query reference the combo box and on the OnChange property of the combo box reference the form to requery.