How do you requery a form from a macro?

  • Thread starter kelly draper via AccessMonster.com
  • Start date
K

kelly draper via AccessMonster.com

I'm trying to requery a form from a macro so that I can add it as an option
to a right-click menu.
when I choose macro option 'requery' i get an error that says i cant use
the applyfilter action on this window. the error suggests using the select
object action to select the form first. so I try that and get the same
error. so, in short, i'm stumped.
how does one requery a form from a macro.
thanks.
 
G

Gaspare

"kelly draper via AccessMonster.com" <[email protected]> ha
scritto nel messaggio
I'm trying to requery a form from a macro so that I can add it as an
option
to a right-click menu.
when I choose macro option 'requery' i get an error that says i cant use
the applyfilter action on this window. the error suggests using the select
object action to select the form first. so I try that and get the same
error. so, in short, i'm stumped.
how does one requery a form from a macro.
thanks.
Click to expand...
Hi,
for use the Requery into the macro you write the source control of your
form...
ok?
 
K

kelly draper via AccessMonster.com

Sorry. I still couldnt get it to work. so I just created a shortcut menu
from the customize... option, added a custom menu option to it and put the
VB code for requerying into the actions field of that menu options
properties, and then just used that shortcut menu as my right-click menu on
my subform. it worked well enough.

thanks anyway.
Kelly
 
Top