I have built an Access database which includes a Navigation form. One of the forms includes a combo box and a command button which, when clicked, opens a report filtered based on the value in the combo box. Here is a slightly simplified version of the query that's having the issue:
SELECT *
FROM tbl
WHERE site Like "*" & [Forms]![NavigationForm]![NavigationSubform].[Form]![comboBox] & "*";
Until today it was working fine. Now, when the button is clicked, an input box appears asking for a value to be supplied for the above parameter ([Forms]![NavigationForm]![NavigationSubform].[Form]![comboBox]). Actually I am working on the front end of a split database, and a copy of the database still works fine and has the exact same where condition. The name of the combo box has not changed. I am actually having this problem with all the controls on any navigation subform. When the problem comes up in VBA code I am able to change it to Me.comboBox, but that won't work in a query parameter.
Since this is working on a copy of the database (but one without other changes to other forms that I'd rather not recreate) but not on this one, I'm not sure what the problem could be unless something is fundamentally wrong with this copy. Is there any way to find out what might have gone wrong? Or any way around this issue?
I changed the name of my navigation form and now everything's working. I still don't really understand why that made a difference since the old form name worked fine up until last week, but as long as it works I'm happy.