Linked Form Criteria

[-ian-]

I've got an interesting problem regarding form opening criteria.

I have four forms (A,B,C,D) which are linked by "forward" and "proceed" buttons. From the stating form A, I can scan to any database entry using the navigation controls. When I find the one I want I can edit data and proceed to the next form using:

stLinkCriteria = "[IncidentNumber]=" & Me![IncidentNumber]
DoCmd.Close
DoCmd.OpenForm "B", , , stLinkCriteria

The problem occurs when I return to the first form. If I use the same kind of filter of the "return" button from form B, I lose my navigation control. If I open without a filter though I return to the first entry by default!

Is there a way to open a form at a specific entry without losing the ability to navigate?

Hoping someone understands,
Ian./

 

[David R]

The problem as you noticed is that OpenForm filters the dataset down to just one record.

Check out either the GoToRecord action/method (you can go to the last record in the list, for example) or the Bookmark example to go to a specific record if you know the criteria, in Access help.

One of those should get you rolling, or check the archives of this site. This question has come up many times before

 

[-ian-]

Thankyou for your patience, I did search the archives, but as I didn't know the name to my problem, so it was difficult.

Have tried now using the Bookmark, and with a little extra help from the archives all is running smoothly.

Thankyou again for your help -it feels great to have this problem put to bed

 

[David R]

My apologies if I came off as snippy before, I wasn't trying to say you hadn't searched, only that once you knew what to look for you should be able to follow along from previous examples.

Glad you got it working.
David R