When using a filter on a combo box, record shows but can't navigate

[gmazza via AccessMonster.com]

Hey there,
I have a form and subform and 6 combo boxes on the main form and the results
get filtered with the appropriate record showing up in the subform. Here's
the problem:
When I open the form it shows ALL records and I can navigate fine. When I
choose any combo box and the subform gets filtered, I can't navigate to any
of the records anymore. It just sits on the 1st record.
Any ideas?
Thanks!

 

[Linq Adams via AccessMonster.com]

I'm a little fuzzy as to exactly what you're doing here, but if you're
applying a filter and that filter only returns one record, you're not going
to be able to navigate to any other record, because the filtered RecordSet
only contains that single record. To navigate elsewhere you'd have to remove
the filter.

 

[gmazza via AccessMonster.com]

The query for the subform returns 13 records. If I choose a combo box, thus
filtering the 13 records, now 5 show up for example. Of those 5, I cannot
navigate to any record but the first one.
When the form first opens, 13 records appear, and I can navigate to any of
them. Seems after my filters are applied I can't navigate.
Thanks for your reply!