How to goto a record on an Access Navigation form?
Posted on 2014-01-08
Issue: I do not know how to use a macro/vba to find/goto a record in a list of records on an access “Navigation” form.
Assumptions: 1) I have a main navigation subform called: FrmAlpha
2) I have a navigation-subform (a tab on the navigation form) called: FrmBravo
3) I have a datasheet (a subform on FrmBravo) that is called: FrmCharlie
4) I have a form I just closed that I used to edited the record I now wish to search for in the FrmCharlie. I shall call this closed form: FrmClosed
I know I will need to use a unique field from the FrmClosed form to find the same record from the list of records on the navigation sub-sub-form (FrmCharlie). I have the underlying table’s primary key [ID] that I figure I can use. Also, I presume I have to affect the focus of the database to look at the navigation sub-sub-form, but I am clueless how to do that. I have seen posts mentioning GoToControl: NavigationSubform, but I am clearly not using that correctly. Help!