Simple question, obvious answer that for some reason eludes me:
I am using the docmd to open a report. The record source for that report is a query that I am looking to filter with a variable that contains user input. So user selects a value from a combobox, value is placed in a variable called RclNbr that is used as such:
DoCmd.OpenReport "affectedVINSrpt", acViewReport, "affectedVINS", "RCC=" RclNbr
I can't get the quotes and tics right in the filter to make it work. Suggestions?