form query criteria messed up due to filter

B

bicyclops

Has anybody had experience with a form's query criteria conflicting with its
filters?

On my form, a number of criteria for the underlying query are set via combo
boxes. These work just fine. I use the form's filter for criteria that was
not conducive to put at the query level. Once I start using filters, the the
form's records get out of sync with the query.

I know this because i can run the query in datasheet mode and see the
correct records but the form doesn't match it. Requerying doesn't help at
this point.
 
R

Rick B

It would help to give us some specifics. Obviously applying a filter will
result in fewer records than the query. Are you saying there are records in
the form that were NOT in the query results?
 
B

bicyclops

Rick- Thanks for the offer; I've since found a workaround. The problem is
that the combo boxes were doing exactly nothing after manipulating the form's
filter via an option group. They were not doing their normal filtering job
based on the query.

I solved this problem by keeping the form's FILTERON setting on all the time
& setting the filter to * when I didn't need it.
 
Top