Refresh/Requery code and location for command button

  • Thread starter Thread starter Keepitlive
  • Start date Start date
K

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
 
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.
Click to expand...
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 <--
 
Back
Top