Refresh/Requery calling form

  • Thread starter Thread starter Jeff PC via AccessMonster.com
  • Start date Start date
J

Jeff PC via AccessMonster.com

(Access 97) I have an update form that can be called from multiple places in
my app. I would like to be able to just have the update form refresh/requery
the calling form, whichever form it was. I've searched this forum and tried
using the OpenArgs property in the calling forms to pass the calling form's
name. So now I can generate a MsgBox in my update form with the name of the
calling form. But then Access doesn't seem to have an Exec() equivalent that
will let me run dynamically generated code,such as:

Exec("Forms![" & Me.OpenArgs & "].requery")

There must be some other way that I am completely missing.

Any help would be appreciated.
 
Jeff PC via AccessMonster.com said:
(Access 97) I have an update form that can be called from multiple
places in my app. I would like to be able to just have the update
form refresh/requery the calling form, whichever form it was. I've
searched this forum and tried using the OpenArgs property in the
calling forms to pass the calling form's name. So now I can generate
a MsgBox in my update form with the name of the calling form. But
then Access doesn't seem to have an Exec() equivalent that will let
me run dynamically generated code,such as:

Exec("Forms![" & Me.OpenArgs & "].requery")

There must be some other way that I am completely missing.

Any help would be appreciated.
Click to expand...

Answered elsewhere.
 
Back
Top