[AccessD] Question about deleteing from datasheet view

Doug,
I think this may be relevant

The Requery method updates the data underlying a form or control to reflect
records that are new to or have been deleted from the record source since
it was last requeried.

The Refresh method shows only changes that have been made to the current
set of records; it doesn't reflect new records or deleted records in the
record source.

The Repaint method simply repaints the specified form and its controls.

Jack

On Thu, Mar 1, 2012 at 11:35 AM, Doug Murphy <dw-murphy at cox.net> wrote:

> Folks,
>
> I have a form in datasheet view that is based on a query. The query shows
> all the records in table A that don't have a child record in Table B. The
> query is a simple right outer join showing columns from table A and a
> criteria on the id field from table B that is set to null. This shows me
> all
> the records in A that don't have a child in B. The objective is to allow
> the
> user to delete some or all of the displayed records. The interesting thing
> is that if a record is deleted from this view I get the "You're going to
> delete one record message" and the record goes away in the datasheet view,
> but if the form is refreshed the record reappears. It would appear that the
> record is removed from the forms recordset clone but not the actual
> recordset. I could swear that I have done this many times in the past and
> it
> always resulted in the record being deleted. Any idea what is going on?
>
> I opened the forms record source query and get the same behavior there.
>
> Thanks in advance.
>
> Doug
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>