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
Expand|Select|Wrap|Line Numbers
- 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