Is there a way to use both record navigation buttons on an Access form and a mouse click to select a record and then display the data in text boxes for editing?

The user wants a tab control placed on a form with two tabs. On the first tab a grid of some kind (subform containing datasheet, or listbox) will display all of the table’s records. The second tab will display the selected record’s data in textboxes for editing.

The Problem: How can I use the form’s record navigation buttons and the mouse to select a record to be displayed for editing on the second tab? The problem I am running into is that only one method can be used either navigation buttons or mouse click, not both together.

Any insight would be greatly appreciated.

Thanks!



katlaw