[AccessD] Selecting Filtered records in Datasheet

[Rocky Smolin]

I'd open a recordset (DAO) using the same select criteria as your filter.
And set all the records' yes/no to True.

Actually, even better, how about an Update Query on the table WHERE (use
your current filtering criteria) updating the yes/no field.  Then a requery
to update the records on the form.

r


-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
David Emerson
Sent: Sunday, June 05, 2016 4:27 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Selecting Filtered records in Datasheet

Hi Listers,

I have a form that is displayed in Datasheet view.  The records can be
filtered using the built in filtering menus.

I want to be able to identify the records that are showing so that I can
update a field (specifically setting a yes/no field to true).  Is there a
property or method that will let me know which records are left when
filtering is applied on a datasheet?

Regards

David Emerson
Dalyn Software Ltd
Wellington, New Zealand




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