As simple as that, appreciate, really if anyone can write the VBA code please, I have the home page, horizontal navigation from which includes many navigation buttons, under NavigationButton7 I have employeesfrm, and I need to navigate Next or previous while I am in the home form , the ID embedded within the employeesFrm, so the VBA code when on unload of the employeesfrm , (not on the home form), is not giving the right ID while I am on the home form. please support..
I have tried Froms!home!navigationSubform!ID , but this will give error cause any ID within any other NavigationButton8 or 9 will give another result, and I am not interested to know the ID of the other forms in other buttons. my concern is just to have a link between the ID within the employeesfrm and the Home form text.
noting is working from the below
Dim MyIDS As Integer
MyIDS = Me.ID ' this is giving only the first ID number all the time.
MyIDS = Forms![Home]![NavigationSubform].[Form]![employeesfrm]![ID] ' this is giving error.
MyIDS = Forms![Home]![NavigationSubform]![Navigationform]![studentsfrm]![ID] ' this is giving error.
MyIDS = Forms![Home]![NavigationSubform].Form![ID] ' this one works but if I am on another Navigation button, lets say 8 not 7, I am not interested in the number...
if anyone wonders why I want this number, I need it for my bookmark, it works fine if I am directly on the employeesfrm, but not on the home form,
thx a lot