Filter does not work.

[tekno]

I am trying to show a group of people using a form with several subforms. I have written a query with say five fields as a filter. When I run the query, it works, but when I run the macro that calls for the form to be used with the query, I get a ??Certain field code??. When I type in the appropriate code, all people using only four of the fields are returned. In other words, it throws up that question box, and then does not filter down far enough. Did I make that obscure enough? By the way, the field in question is on a subform in the main form.

 

[cogent1]

Do you mean that it is prompting you to enter a parameter value and then not using that value? Sounds like a misspelling of one of your field names...

 

[tekno]

I have done a little research, and to rephrase the problem, it would go like this. I have data on individuals in several tables. The main table contains their demographics and other static data. In other tables are their ID Codes and other attributes. I have a main data input screen with subforms, into which all data is entered. I wrote a filter to show group records, but the queries that ask for subform attributes do not show those individual's data in the main input form.