Can 1 form refresh another form?

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


LVL 4
get-ADuser -F ($_.Name -eq "Todd")I.T. ManagerAsked:
Who is Participating?
 
rockiroadsConnect With a Mentor Commented:
u could try

forms("frmSelector").Form.Refresh

0
 
mbizupConnect With a Mentor Commented:
Yes--
To requery the other form:
Forms!frmSelector.requery
0
 
get-ADuser -F ($_.Name -eq "Todd")I.T. ManagerAuthor Commented:
Thanks
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
get-ADuser -F ($_.Name -eq "Todd")I.T. ManagerAuthor Commented:
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
 
mbizupCommented:
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
 
rockiroadsCommented:
Hi netcepter
dont worry about it, fact u acknowledged my solution worked is good enough for me :)
0
All Courses

From novice to tech pro — start learning today.