Problem after apply filter

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

Guest

I've a form on a table wth two required fields. If no rows meet the filter's
criteria, I can't remove the filter(by clicking 'remove filter' icon) until I
enter data to the required columns. And a new row is added after filter is
removed. Does anyone encounter similiar problem or know what I did wrong?
your help is much appreciated.
 
You can get out of the box by pressing the <Esc> key.
Pressing Esc twice should let you out without saving a record.

It would be good to find out why you are getting stuck in there. Unless you
actually typed something, it should not have begun a new record, so you
should not get stuck. You might want to check if something else is dirtying
the record, e.g. if there is some code in the Current event of the form that
assigns a value to one of the bound fields.

The Esc key is simplest, but you can also use Undo on the Edit menu, or the
Undo button on the toolbar.

Of course, if there is code in the Exit event of the control, that code
might still not let you out.
 
Allen:
Yes, you're right. I use different row source for filter and the regular
form and I did have requery in the current form event. I change the current
form event to only requery if form.filteron is false and no more problem.

Thanks for your help.

Anna
 
Back
Top