Question about form/inconsistent updates

[Ellen Manning]

I've got an A2K continuous form based on a query of 2 tables. The
query returns results if the field "Outstanding" = Yes. The form's
recordset type is set to Inconsistent Updates. If the user changes
"Outstanding" to No, then the form automatically refreshes itself,
displaying only the records with Outstanding set to Yes. How do I
stop this automatic refreshing? I want the records the user may
change to No to stay on the form.

Thanks for any help or advice.

[Mike Storr]

Is there code or a macro in an AfterUpdate or similar event of the control
that Outstanding is changed in causing the form to refresh? Is the
recordsource of whatever you are using to display the results refering to
the "Outstanding" control?

Mike Storr
www.veraccess.com
"Ellen Manning" <ma**********@hotmail.com> wrote in message
news:da*************************@posting.google.co m...

I've got an A2K continuous form based on a query of 2 tables. The
query returns results if the field "Outstanding" = Yes. The form's
recordset type is set to Inconsistent Updates. If the user changes
"Outstanding" to No, then the form automatically refreshes itself,
displaying only the records with Outstanding set to Yes. How do I
stop this automatic refreshing? I want the records the user may
change to No to stay on the form.

Thanks for any help or advice.