Refreshing a main form

G

Guest

Hi,
I want to know what's the code that i should write in the Afterupdated
event of a textbox placed in a subform called "expenses" in order to refresh
the parent form (called "Operations").
I want to refresh the main form with its subfioms...
Can anybody help?

Regards
 
A

Arvin Meyer [MVP]

Me.Parent.Refresh

or

Me.Parent.Requery

depending upon the circumstances. Requerying starts the recordset at the
beginning. You may also want to save the record before doing either:

DoCmd.RunCommand acCmdSaveRecord

or better:

Me.Parent.Dirty = False
 

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

subform-on Main form not refreshing queried job list 2
Main / Sub Form 3
mirror data from subform to main form 3
Syntax for Refreshing Control on Sub-Subform 6
form still on task bar 1
Access Sub form opens before the main form in MS Access 0
Problem with form--subform 5
Link subform ID control 3

Top