Placement of active control when moving between forms....

[FeedMeAccess]

I am trying to do the following:

I have an employee database that is based on one table of information. From this table of information, I was able to create different forms displaying certain information. The main screen displays a listing of employees categorized by office location. These locations are displayed in a tab format. The database is currently set-up for users to navigate to different forms based on their level of access (I don’t think that those securities will apply on this copy w/o the security file.). Users would normally press the “general information” button and advance to the “general information” form. The record they default to is based solely on how they were sorted initially. We would like the following scenario to happen: if I am on the record for “Dave Smith” on the main form, when I click the “general information” button, that form will default to the record for “Dave Smith” – and vice versa. Any thoughts?? THANKS -- FeedMeAccess

 

[Guest_imported]

It sounds like the rest of your forms are bound to the same record set as the main form. You could try to use the current record on the main form (the one currently selected)and then when the user clicks a button to navagate to another form, set the record source for that form to the selected record.