Requery & Focus of a Hidden Form

[mlr]

On Command Button [Update] = Requery + unhide Form1 then Close Form2:

How to I set the focus of form1 [FA003].Field to match that of form2’s [FA004].field?

Please see attached.

Thank you
Mark

 

[mlr]

Found the solution, thanks to vbaInet's post:

    Dim pos As Long
    
    pos = Parent!SubformName.CurrentRecord
    Parent!SubformName.Requery
    Parent!SubformName.Form.Recordset.Move pos

Kind Regards
Mark