Form/Subform Refresh

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
 
S

strive4peace

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 :)
*
 

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

Similar Threads

using vb code to move the record selector of a SubForm 1
subform calls 1
Refresh/OnCurrent Questions 3
continuous form records on subform 2
Subform Refresh 1
Ref. to a variable in another form? 1
passing record from one form to a subform of another form 4
Show Value in Tab Page Subform control in Other Tab Ctrl Pg Sbfrm ctrl 0

Top