Query with hidden field drops the field.

[Jen]

I filter records by sending values from an unbound textbox / submit button
like this:

stLinkCriteria = "forklaring Like '*" &
[Forms]![startform]![txt_bladdra_per_fritext] & "*'"

The problem is that the fields "forklaring" is in a subform of the form that
should show the filtered records. There can be many "forklaring" fields in
the subform embedded on the main form as they are in datasheet view. I can't
have "forklaring" in the mainforms query because then I get duplicate
records no matter if I have "Select distinctrow" in the main forms query.

If I put the field "forklaring" in the mainforms query and uncheck "Show" in
the Querygrid then everything works fine, I can seek values from the
"forklaring" and doesn't get any duplicates of the records shown in the main
form. However when I restart the database the "forklaring" with the
unchecked "Show" has disappeared from the query alltogether, thus prompting
for "forklaring" when I try to filter the records again.

Tried also to bind a subquery to the main query with the "forklaring" fields
but with no success.

Jen.