filter by form and vba

A

andy

Hello

This just drives me up the wall....
I have a form with a subform and another subform.... the main form is not
bound to any table, it just serves as a command center for other subforms
are in spredsheet view.

the first subform is based on a parameter query (the parameter is taken form
a form, so there is no prompt for it).
when a user applys a filter by form it works fine until user removes filter.
then the form locks on the most recent recordset. Only way to correct this
is to open filter by form and clear the grid an close the filter by form.
after that everything gets back to normal.

can any one help ?
me.task.form.filter = ""
me.task.form.filteron = false
don't work
when i open the query by form it still has the previous selection.


please help !!!!!!!!

andy
 

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

Top