Form Returns to First Record

[CanWest]

Hi Everyone

I have searched for this with no luck. Here is the scenario.

I have a new database developed in Access 2013. In this I used the Navigation Form that has been around since Access 2010.

I have four 'Tabs' set up each with it's own subform for various parts of the database.

I'll use two of those tabs in my Explanation, Clients and Employers.

Let's say I am scrolling through my clients and get to client id number 28 (Or any number for that matter). I want to switch to the Employers tab and do so and scroll through the Employers. Once I have found a matching employer I click on the clients tab again (And here is the problem) the form starts out on the first record again. My question is how do I make the clients form STAY ON the record it was when I left the form to go to the Employers tab

Any ideas will be greatly appreciated.

 

[Ranman256]

Open the form via the key id#

docmd.openform "frmDetail",,,"[clientID]=" & txtID

 

[CanWest]

Open the form via the key id#

docmd.openform "frmDetail",,,"[clientID]=" & txtID

The form is already open on the clients tab. It just returns to the first record when returning to that tab from one of the other tab

 

[arnelgp]

that is the "Normal" behaviour of Navigation form (that is why i never used it). it always requery the underlying subform whenever you switch tab to it.

there is a simple solution, but some expert in this forum disapproved of this method, although this is documented in all Access books i have read.

 

[CanWest]

Ok i'll bite. Whats the simple solution