Form/Subform Refresh

  • Thread starter Thread starter sivancr
  • Start date Start date
S

sivancr

Hi! i really suck at programming... however i'm trying to build up a small DB
to simplify some stuff, now... i have a formA which contains subformB (this
is mearly an add up query from the values input into subform A), and i want
for subformB to update it's content when the records are entered entirely, or
is there another way to do it, such as using an expression on a label
 
try this:

1. turn on the properties window
(right-click somewhere on the form and choose 'Properties' from the
shortcut menu)
2. choose the form object from the drop-down at the top of the
properties window
3. in the properties window, click on the 'Events' tab
4. click in the AfterUpdate event for the form
5. from the combobox, choose --> [Event Procedure]
6. click on the builder button [...] on the right
7. this will take you to code -- the procedure declaration and the 'End
Sub' statement will already be there for you

between these two lines, type -->
me.subform_controlname.form.requery

WHERE
subform_controlname is the NAME property of the subform control


Warm Regards,
Crystal
remote programming and training

Video Tutorials on YouTube!
http://www.youtube.com/user/LearnAccessByCrystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*
 
Back
Top