How to requery a form from sub form

  • Thread starter Thread starter a
  • Start date Start date
A

a

access 2007

How to requery a form from sub form

Example:

I have master form with 2 subform, the 2 subform have the same (data source)

I want when edit one of them the edit apply to the other form
 
Add this code to the appropriate event in Subform1:
Me.Parent.subformControl2.Requery, where subformControl2 is the name of the
subform control that contains your 2nd subform.

I don't remember the precise syntax for this so you might need to add .Form
in one or two places:
Me.Parent.Form.subformControl2.Form.Requery
 
Hi ,

How is everything going? Please feel free to let me know if you need any
assistance.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
 
Back
Top