How to requery a form from sub form

[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

 

[a]

i'm sorry
the question is How to requery subform from subform on the master form?

 

[Paul Shapiro]

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

 

[Wei Lu [MSFT]]

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.