Solved

Can 1 form refresh another form?

Posted on 2006-11-21
7
280 Views
Last Modified: 2008-02-01
I have frmRetailName that needs to refresh frmSelector either when I run it's append query command button or when it exits out.

using this code:
DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70

I can refresh frmSelector with its own button but it's an extra step.   I need frmRetailName to do it.  Is this possible?


Thanks in advance.
Net


0
Comment
  • 2
  • 2
  • 2
7 Comments
 
LVL 65

Accepted Solution

by:
rockiroads earned 100 total points
ID: 17989960
u could try

forms("frmSelector").Form.Refresh

0
 
LVL 61

Assisted Solution

by:mbizup
mbizup earned 50 total points
ID: 17989961
Yes--
To requery the other form:
Forms!frmSelector.requery
0
 
LVL 4
ID: 17990076
Thanks
0
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
LVL 4
ID: 17990134
rock,

Thanks for you answer.  The requery worked, but it went back to the beginning.  The refresh code refreshed it at its current record.  That's kind of what I was looking for.  I was a little quick to accept without giving you some points. I appologize.  Yours worked and I wanted to give you recognition.  Thanks to both.

Net
0
 
LVL 61

Expert Comment

by:mbizup
ID: 17990152
Netcepter,
You can post a note in community support with the URL to this question, and ask that they reopen it so that you can set this straight...

Thanks
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 17990217
Hi netcepter
dont worry about it, fact u acknowledged my solution worked is good enough for me :)
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How can you open the FORM2 2 31
vba sql wild card passing in code 3 23
Reference Controls on subforms 7 28
Need help constructing a conditional update query 16 43
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question