[AccessD] Question about deleteing from datasheet view

Doug Murphy dw-murphy at cox.net
Thu Mar 1 10:35:43 CST 2012


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



More information about the AccessD mailing list