Requery by Pop Up Form

  • Thread starter Miguel via AccessMonster.com
  • Start date
M

Miguel via AccessMonster.com

I have a pop up form with a few combos, which I use as the criteria to run a
query. When I click the button to run the query everything works fine.
However, if I select other criteria from the combos, when I click the button
it doesn't requery. I'd just like to "requery" the parameter query from the
pop up form various times with the pop up form always open. Would be nice.
But that's not happening. Any ideas?
 
D

Dan Dang

Suggestion:

Create a command button on your form, and apply the following code:

Private Sub Command0_Click()
DoCmd.Close acQuery, "yourqryname"
DoCmd.OpenQuery "yourqryname", acViewNormal, acEdit

End Sub
 
Top