Navigating Using Button

[LegionKilo]

I have to forms:

1. Employee Entry
2. Training Records Entry

On each form is a button to navigate from one to the other and back again if necessary. A challenge I have is when I do that it starts over at the first record. Example: I'm entering/editing a person with the last name that starts with R in Employee Entry. I need to update their new hire training records so I navigate over to the Training Records Form and it always starts at letter A. If I were to navigate back to Employee Entry, it too would begin back at letter A.

Is there a way to navigate between these forms and remain on the current record?

Please keep in mind creating a person in one form automatically creates them in the other.

 

[CJ_London]

assuming you are using docmd.openform, there is a parameter you can use to find a particular record when the form opens - something like

docomd.openform "myForm",,,"PersonID=" & me.PersonID

Another alternative is to just add your training form as a subform to your persons form - make sure the linkchild and linkmaster properties are completed and you don't need any code

 

[LegionKilo]

CJ_London,

I'm not using that to navigate. I made a button and it executes with an 'on click' macro. I don't really know VBA or SQL at all. I would be in way over my head.

 

[CJ_London]

you need to look at and edit the macro. I don't use them, so can't advise. What I do know is that a macro executes one or more commands, in this case the command will be called openform and will have options you can complete which are the equivalent of the parameters I referred to.

Alternatively you have the option to convert a macro to vba, then you can use the solution I provided.

Or use the subform suggestion, then you don't need code or macro.

If you want access to do anything other than the very basics, it's time to jump in and start swimming.