Refresh/Requery code and location for command button

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
 
S

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 <--
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top