OpenArgs

[Guest]

I have a form that displays a flexgrid. I click a button on the form which
opens a popup form where I set the criteria for what I want displayed on the
flexgrid. After the criteria is set I reopen the flexgrid form (which was
never closed) and close the popup form. I pass the criteria that was set on
the popup using OpenArgs in my OpenForm statement. I'm having trouble finding
which event fires on my flexgrid form when I close my popup form so I'm
unable to use the criteria in my OpenArgs statement. I've tried On Current,
On Open, On Load but none of these events fire. Am I going about this the
wrong way?

 

[Guest]

Here is a suggestion:

1- use the popup form to build a query string with all the criteria
2- set the string to be the record source for the flexgrid
3- immediately refresh/requery the flexgrid

 

[Arvin Meyer [MVP]]

If you are re-opening the form, I would try using the Open event. If that
doesn't work, try closing, then opening. The control on your form, set to
receive the OpenArgs argument, may not have loaded until the Open event.
OpenArgs is an Access defined global variable. Because it is a global
variable, it may be susceptible to errors (global variables tend to go out
of scope and lose their values upon errors).