Form Navigation

[Manuel]

Hi,

I have a form with a tab control with several pages (tabs) which contain a
sub form. Here’s what I’m trying to do:

The first time the user navigates to a tab (let’s call it Page 1) with a
subform I want the subform to automatically navigate to a new record (I think
I’ve figured out how to do this, but I’m having trouble with the rest).

Once the user enters a new record or navigates to an existing record on the
sub form on Page 1, I want the form to bookmark this record such that when
the user navigates to any of the other tabs (say Page 2) and then navigates
back to Page 1, the bookmarked record is the record that is displayed.

I’ve figured out how to always direct the user to a new record, or only
direct the user to a new record upon their first visit to the
tab/page/subform. However, upon subsequent visits the form automatically
navigates to the first record.

Please help.

Thanks,

Manuel

 

[AccessVandal via AccessMonster.com]

Try this on the current event of the subforms or the Tabs click event.

DoCmd.RunCommand acCmdRecordsGoToLast

Hi,

I have a form with a tab control with several pages (tabs) which contain a
sub form. Here’s what I’m trying to do:

snip...