[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Can 1 form refresh another form?

Posted on 2006-11-21
7
Medium Priority
?
313 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
6 Comments
 
LVL 65

Accepted Solution

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

forms("frmSelector").Form.Refresh

0
 
LVL 61

Assisted Solution

by:mbizup
mbizup earned 200 total points
ID: 17989961
Yes--
To requery the other form:
Forms!frmSelector.requery
0
 
LVL 4
ID: 17990076
Thanks
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
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

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

Question has a verified solution.

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

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

830 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