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
 
i'm sorry
the question is How to requery subform from subform on the master 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.
 
You must log in or register to reply here.

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

Refresh data in sub forms when one sub form is edited 4
subform based on external SQL won't requery 1
Requery main form after subform update and not lose place in main form. 1
Requery table from form 4
requery not working 7
Find prev record on other requeried form 2
requery continuour subform 11
"save" button not requerying as coded 3

Back
Top