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.

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.