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

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1051
  • Last Modified:

MS Access (Open, Load or Current)

Hi-
This is more of a general question...
I know that the form procedure for reading code is:
Open ’ Load ’ Resize ’ Activate ’ Current

I have a main form -- this is closed when some of my smaller forms are opened because I wanted to be able to refresh the main form when it's re-opened.

Is this optiminal? Or should I skip using code in the Open and move it to Load or Current instead?
Thanks, Stacy
0
stacydr
Asked:
stacydr
  • 2
  • 2
1 Solution
 
manthaneinCommented:
have you  tried   mainform.requery?   instead  of closing the  main  form?

0
 
stacydrAuthor Commented:
I was thinking of removing the close feature and adding the requery in the Current event?
What do you think?
I'm just trying to have the smoothest flow..
S.
0
 
manthaneinCommented:
yes  removed the closing of the form..     then  set the  smaller forms  modal  value  to  true..so they can't get back to the main form  without  closing the  mini-forms  first..

if you're  going  to use  this. better  use  OnActivate or GetFocus method of the mainform,, then  requery it..
0
 
stacydrAuthor Commented:
thanks = sorry for the delay
0

Featured Post

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!

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