Go to current record after closing and opening the form

[metad]

Hi. I have a form which has a lookup function. The lookup field (a combination box) is collect information about 8 fields from a query. The problem is that I can not see the information before I close an reopen the form. When the form reopens, it goes to the last record. I know that I can get it to go to the first or to the next, but how can I go to the last record I was working in (Current record)? Or is there any possibility to see the information without closing and reopening the form?

Here is the code for updating the form:
DoCmd.Close acForm, "myform"
DoCmd.OpenForm "myform", acNormal, "", "", , acNormal
DoCmd.GoToRecord acForm, "myform", acLast

Thanks in advance.

 

[metad]

Could you please explain more

Dear Pat, Thank you for your response. Could you please explain a little more "requerying the form and searching for the key of the record"? Thanks in advance.

 

[metad]

Thnak you again.

I have find the solution with requering metode.