Reopen form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to have a command button that reopens the form my users are
using. How can I do something like this?

Thanks,
john
 
Can you be more specific? What do you mean by "reopen" and when would you
want that to happen?
 
I have a form that uses a filter when it is opened. After the user is
finished with the current filtered records, I would like for them to be able
to click a command button that would close the current form and reopen it.
At this point when it is reopened, the user would enter information for the
filter process. Thanks for your help!
 
Why close the form?

Why not just kill the filter?

You are looking for a solution that has more pain then the cure!!

if you got a filter, then either have the user go:

records->remove filter sort...

Or, in code, just go:

me.filter = ""
me.Filteron = false

me.requery


I am at a loss as to why you need to close the form.....
 
Okay, gotcha. There is a better approach. Rather than close and open the
form, just change the filter criteria and requery. You can put the code
behing a button.

'Do whatever to deterime your filter criteria here
Me.Filter = ' your filter criteria
Me.Requery
 
(__)O Here's some hot coffee Albert 8-)


Klatuu said:
Okay, gotcha. There is a better approach. Rather than close and open the
form, just change the filter criteria and requery. You can put the code
behing a button.

'Do whatever to deterime your filter criteria here
Me.Filter = ' your filter criteria
Me.Requery
Click to expand...
 
Back
Top