[AccessD] Question about deleteing from datasheet view

After realizing what was going on I just changed the query to use a subquery
to find the records to delete and it worked fine, except it is much slower.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Simms
Sent: Friday, March 02, 2012 5:52 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Question about deleteing from datasheet view

Only solution appears to be:
Delete the record in the table via query or SQL, and then requery the form
to refresh the recordsource.

>     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.
>


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com