I am designing an Access database that will use tab controls. Normally, you place different sets of fields on each page of the tab control – like Fields1-3 on Page 1, Fields 4-6 on Page 2, etc. In my database, however, I want to associate a particular numbered record of a field with each separate tab.
In exploring my options, it looks like the best way to do this is to add a record-navigating “On Click” event to each separate page of the tab control. The command button wizard will allow me to select the option of navigating to the first, last, next, or previous record – but not to a specific numbered record.
For grins, I have created a sample record navigation button – like GoToLastRecord. When I click on the Event Procedure in the button’s properties, it brings up a Visual Basic window with the underlying code for the button I just created. (As of now, I know very little about the Visual Basic language.)
My main question is either a) is there readily-accessible, existing code for navigating to a specific record X, or b) how would I modify the code generated for the button I made to make the database jump to a specific record X? Also, I need general instructions on how to locate the code file for the button I made; I presume I will need to store my “new” code file in the same place.
Thank you for any help you can offer!
John Osborn
Dept. of State Health Services
Austin, Texas