• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 802
  • Last Modified:

Ms Access - refresh a form from another form

I have a form named "F-100-05 PU Graphic Select" in which I have the user click a selection button. When the user clicks this selection button I want the form listed above to update a graphic in a subform of another form that is presently open. The name of the subform is "Forms![F-100-04 Add New PowerUnit]![F-100-06 DisplaySelPu].Form "

The name of the form and field is "Forms![F-100-04 Add New PowerUnit]![F-100-06 DisplaySelPu].Form![PU Graphic] "

All assistance would be appreciated.

LAD
0
Lou Dufresne
Asked:
Lou Dufresne
  • 3
  • 2
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Try this

Private Sub btnUpdateGraphic_Click()

Forms![F-100-04 Add New PowerUnit]![F-100-06 DisplaySelPu].Form![PU Graphic] = "SomeNewGraphicName"

End Sub
0
 
Lou DufresneIT Business Analyst CSM / Project ManagerAuthor Commented:
Unfortunately I conveyed this incorectly. What I need to do is Refresh or requery the Mai oe sub form,

I need to refresh or Requery Forms![F-100-04 Add New PowerUnit] or "Forms![F-100-04 Add New PowerUnit]![F-100-06 DisplaySelPu].Form "  when the user clicks the selection button on "F-100-05 PU Graphic Select".

Can I use Forms![F-100-04 Add New PowerUnit].refresh or Forms![F-100-04 Add New PowerUnit].Requery to update the original form?

LAD
0
 
ioanePlanning & Analytics ManagerCommented:
If this is a subform on a different form from the one you are clicking the button on you need to reference the main form first.

i.e.

Forms![F-100-04 Add New PowerUnit]![F-100-06 DisplaySelPu].Form.Requery
0
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
Lou DufresneIT Business Analyst CSM / Project ManagerAuthor Commented:
Thanks for you assistance
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
"Unfortunately I conveyed this incorectly."
Yes, unfortunately ....

mx
0
 
Lou DufresneIT Business Analyst CSM / Project ManagerAuthor Commented:
DatabaseMX
     Please respond to my latest question. I believe this is the question I should have asked

LAD
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now