See Attached Db's (Filtering Form Using Query)
Please find the 3 attached MS Access 2000 databases that have been considerably simplified in order to demonstrate my dilemma.
I want to know why Db1 works and Db2 and Db3 do not.
The desired result is to run “Macro1” and have it perform the single action of opening the only form and have it show only 3 of its 42 records (the ones where the technician’s name includes the letters “jab”). If you run “Query1” by itself in any of the databases, Query1 achieves this result and displays the proper records (Test #’s 2003-0003 , 2003-0005, and 2003-0010 ). However, when ‘Query1’ is used as a filter for the form, only the one that is ‘hard-coded’ in Db1 works. This ‘hard-coding’ of the criteria in the query is unacceptable and I need a work-around. Db3 is another example of a work-around that fails. I do not want to prompt the user for any input. All the necessary search criteria / values are included in “Experiments_Search_TBL” (a detail not important to answering my question).
All three databases are identical except for “Query1”. You can follow the hierarchy of Query1 inside the database.
PLEASE HELP!!!!
Please find the 3 attached MS Access 2000 databases that have been considerably simplified in order to demonstrate my dilemma.
I want to know why Db1 works and Db2 and Db3 do not.
The desired result is to run “Macro1” and have it perform the single action of opening the only form and have it show only 3 of its 42 records (the ones where the technician’s name includes the letters “jab”). If you run “Query1” by itself in any of the databases, Query1 achieves this result and displays the proper records (Test #’s 2003-0003 , 2003-0005, and 2003-0010 ). However, when ‘Query1’ is used as a filter for the form, only the one that is ‘hard-coded’ in Db1 works. This ‘hard-coding’ of the criteria in the query is unacceptable and I need a work-around. Db3 is another example of a work-around that fails. I do not want to prompt the user for any input. All the necessary search criteria / values are included in “Experiments_Search_TBL” (a detail not important to answering my question).
All three databases are identical except for “Query1”. You can follow the hierarchy of Query1 inside the database.
PLEASE HELP!!!!
Last edited:
