Refresh/Requery code and location for command button

[Keepitlive]

Please help. I cannot figure out how to refresh (requery) a record in
a subform.

Main form is frmClient
Subform is frmClientReferralsubform (subform and source form have same
name), set to Continuous forms. Each record is a single line of read-
only fields and an Edit button. Clicking one of these buttons opens
form frmReferral with the relevant record displayed for editing.

I can't figure out the correct code to reflect any changes on the
original subform when frmReferral is closed OR which event to use to
trigger the code.

I'm afraid my attempts to research this have just left me more
confused
Thanks in anticipation

Chas

 

[Stefan Hoffmann]

hi,

I can't figure out the correct code to reflect any changes on the
original subform when frmReferral is closed OR which event to use to
trigger the code.

Open your frmReferral as dialog as this will stop the code excution
while the form is open:

DoCmd.OpenForm AFormName, , , , , acDialog
Me.Requery


mfG
--> stefan <--