[AccessD] Question about deleteing from datasheet view

Doug,

    The underlying reason for the behavior experienced by you can be considered inherent to the nature of an outer join, when such a query is filtered to show only Nulls on the many side. In this set up, deletion of a record via user interface, is tantamount to deletion of a non-existent record. 

    Temporary disappearance of displayed record in question (preceded by warning message) is a sort of illusion. It relates merely to removal of a virtual row, corresponding record for which was never there to start with.

Best wishes,
A.D. Tejpal
------------

  ----- Original Message ----- 
  From: Doug Murphy 
  To: 'Access Developers discussion and problem solving' 
  Sent: Thursday, March 01, 2012 22:05
  Subject: [AccessD] Question about deleteing from datasheet view


  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