Hi there.
I am new here. I'm haviung a prolem with Access and I can't find the solution anywhere so I hope that someone here will be able to help me.
In my Database I have a "Main Menu" form which has "double" set od tabs. So first there are tabs "Inevntory", "Invoicing", etc. When you click "Inventory" the other set of navigation tabs shows "New Item", "New user", "Lending", etc. All of this was created using the "Naviagtion Control" from "Form Design" tab. What I need is when I (for example) go to "Inventory" and then "New Item", the form that opens (New Item Entry) needs to show the last record entered. How do I do that? I have tried a bunch of dfferent things and nothing worked. This tutorial:
wasn't usefull because in my case these arent buttons that open another pop-up form but Navigation form which is all-in-one pop-up.
Update:
I have managed to add this code
Private Sub MainMenu_NavigationSubform_Enter()
DoCmd.RunCommand acCmdRecordsGoToLast
End Sub
but what happens is it loads the latest record when I open the form for the first time, but then when I (for example) go to "New user" it starts from the first record and then when I go to "New item" it is also back to first record.
Note: MainMenu_NaviagtionSubform is my name for the subform that opens after you select "News user" or "New item".
I am new here. I'm haviung a prolem with Access and I can't find the solution anywhere so I hope that someone here will be able to help me.
In my Database I have a "Main Menu" form which has "double" set od tabs. So first there are tabs "Inevntory", "Invoicing", etc. When you click "Inventory" the other set of navigation tabs shows "New Item", "New user", "Lending", etc. All of this was created using the "Naviagtion Control" from "Form Design" tab. What I need is when I (for example) go to "Inventory" and then "New Item", the form that opens (New Item Entry) needs to show the last record entered. How do I do that? I have tried a bunch of dfferent things and nothing worked. This tutorial:
Update:
I have managed to add this code
Private Sub MainMenu_NavigationSubform_Enter()
DoCmd.RunCommand acCmdRecordsGoToLast
End Sub
but what happens is it loads the latest record when I open the form for the first time, but then when I (for example) go to "New user" it starts from the first record and then when I go to "New item" it is also back to first record.
Note: MainMenu_NaviagtionSubform is my name for the subform that opens after you select "News user" or "New item".
Last edited: