Bean Machine
Member
- Local time
- Today, 06:16
- Joined
- Feb 6, 2020
- Messages
- 102
Hi everyone! I am currently in the process of making a graph that can be filtered based on values in a combo box. I build a query specifically for the graph that contains the year, the grouping codes associated with items (basically tags), and the total amount spent per grouping. Usually using the phrase Like "*" & [Forms]![form name]![control name on form] & "*" in the criteria section of the fields I want to be able to filter to works completely fine and does the job, but for whatever reason I am getting the error "The microsoft access database does not recognize "[Forms]![frm_SSNR]![cbx_DDS]" despite the form name being correct as well as the combo box name being correct. The combo boxes are unbound as well if that means anything, I'll include some images.