Maintaining a Filter

L

Lloyd

I am using a continuous form displaying several records with a button for
each record to move to more detail about the individual record. The Filter
by Selection or Filter by Form options are available. The button relies on a
macro to open the detail form with a where statement to go to the correct
record.

Can I add a filter statement in the macro to maintain access to the
previously displayed records when I go to the detail of an individual record?
As I currently have it designed, the detail form opens and indicates that I
have filtered to a single record. What kind of a statement do I need to add?
Or do I need to add some VB to accomplish this?

Thanks, Lloyd
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top