Filtering form with checkbox

serose14

New member
Local time
Today, 13:18
Joined
Oct 30, 2015
Messages
2
I am trying to make changes to an existing Access database written by someone else. A form is used to display rows of information on screen. I am trying to hide rows as the tasks become completed based upon entry in a particular field. The list is a list box that's source is a union query, whose source is a linked table, that is linked to a table in another database file. I am attempting to hide rows by filtering them, using a checkbox. Ultimately if the check box is checked, it hides the filtered rows. If it is unchecked, all records should show. Whenever I try to use a filter, I get an error "The object does not contain the Automation object "x". I've tried referencing everything except the external database table, which I wouldn't know how to reference. Any ideas?
 
A column in your query is not correctly specified.
 
I find that hard to believe as I have used the expression builder and get the same error message.
 
Post the form record source SQL and if you're using the Filter property, the Filter property SQL.
 

Users who are viewing this thread

Back
Top Bottom