Refresh, requery, or what?

[Ivor Williams]

I have a form with a subform. The data source for the subform is a table. On
the main form is a command button which, when clicked, opens a pop up form.
When the pop up form is filled in and closed, I want the information in the
subform to be updated to include the information added in the pop up form
without having to close and reopen the main form. Can someone clarify for me
the VBA code to do this. I'm obviously not understanding the differences
between Repaint, Requery, Refresh, ShowAll, etc.

Also, I have difficulty with syntax when referring to controls in subforms.
Can someone please clarify for me how properly to refer to controls in both
a form and a subform.

Thanks,
Ivor

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "SubformReference2k.mdb" which explains and illustrates how to
reference forms, subforms, and sub-subforms.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[George Nicholson]

Can someone please clarify for me how properly to refer to controls in

both a form and a subform.

Forms: Refer to Form and Subform properties and controls
http://www.mvps.org/access/forms/frm0031.htm