Requery by Pop Up Form

  • Thread starter Thread starter Miguel via AccessMonster.com
  • Start date 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?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top