... I had the stored query in both the front-end and the data file. The "IsImportan t" field existed in the front-end, but not the data file. Thank you so much, sorry to waste your time on such a trivial issue.

I just double, and triple checked those things. It is typed correctly, it is a yes/no, and the default value is false.

Here is some more information that will hopefully help:

This database is split. I have a development environment and a production environment for this database. In the development environment, the data is stored on the local hard drive. The production environment stores the front-end on the local hard...

Yeah, it's on line 39.

I'm trying to figure out why I'm getting this error. I'm relatively inexperienced. The nature of the following code is that a slightly different query is run whether or not the "ImportantDates Only" flag is true or not. The problem is that the query that runs while the flag is true fails, and the query for when the flag is false does not fail. The error occurs at db.OpenRecordse t (last line in the code segment). The failing query does...