Solved

Can 1 form refresh another form?

Posted on 2006-11-21
7
293 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

733 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