form filter issue

[spinkung]

hi

i filter a form based on a selection in another form. problem is when i go back to the filtered form i can no longer cycle through records. only one record is available (the filtered) or i can add a new record.

is there a way to select the record and also still be able to cycle through the rest of the records?

Thanks

 

[John Big Booty]

I'm guessing that you are using the Where condition of the OpenForm method.

What I would do is use the OpenForm method (without specifying a where condition) to open the form, then in it's On Current event us the FindRecord method to find the record you are after. You will of course need to use the OpenArgs portion of the OpenForm method to pass the RecordID to the form being opened and use that in your FindRecord method.