Hello- I have an access 2010 db that i have been developing for almost a year. I have a list box, based on a query, that filters a form... for no explainable reason i now get the error message "2101 the setting you entered isn't valid for this property".
I have not changed any of the properties of my list box, or my form. The weird thing is, the folks that i am creating the db for have the exact same front end and back end, and they do not get the error message.
Also, if I click on a name in the list box I do not get the error, but if i type in the name i want to filter for (something I have always been able to do from the very beginning) i get the error.
After i click "ok" twice on the error message i am able to proceed with the name selection, and the form filters.
I have tried running the repair function for office pro from the "my computer, control panel," which didn't work, and i have compacted and repaired the file, which didn't work. Does anyone have any suggestions what to do?