On SubForm Close Go back to the Record I was on

[samjh]

Hi Appologies if this is already on here, I have searched but can't find what i am looking for.

I have a form with client information on it (based on a table).
This has a subform with commitment information on it (based on a query).
On the subform I can add a new commitment, or double click to edit/delete one of the commitments that are already there.
Each of these actions opens the commitment form (based on a table).
When I then close this commitment form, to go back to my original form with subform, I have some code in there to requery so that I can see the changes that have been made.
However my problem is that when I close the commitment form, to back to the form/subform, it takes me to the first client instead of the client I was on.

Can anyone show me what I need to do to go back to the client I was on please.

thanks.

 

[samjh]

Hi,

After reading your reply, I realised I had entered my form the wrong way, as if I use a client search first then it filters the form to one client.

thank for you reply.