Reopen form

[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

 

[Guest]

Can you be more specific? What do you mean by "reopen" and when would you
want that to happen?

 

[Guest]

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!

 

[Albert D.Kallal]

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.....

 

[Guest]

Calm down, Albert. I think he just did not know this option was available to
him.

 

[Guest]

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

 

[Gina Whipp]

(__)O Here's some hot coffee Albert

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