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.

 

[Pat Hartman]

One of the parameters is not properly spelled, that's why you're getting the prompt.

Also, it's not clear to me whether you are trying to filter the main form or the subform. The filter property does not work with subforms. The only way to filter them that I have found is to build an SQL string that includes the filtering parameters and use that string to replace the subform's recordsource. You will have to requery the subform after you replace its recordsource to get the filtering to occur.