Filter Property

[Ken Hutson]

Hi Group,

Is it possible to filter distinct rows on a table which is opened
cmdTableDirect?

Ken Hutson
San Antonio, TX

 

[[MVP] S.Clark]

Opening a table directly like this isn't recommended.

I think this is a recordset... If so, then open it using a query with the
desired criteria instead.

Steve Clark

FMS, Inc.

http://www.fmsinc.com/consulting

703-356-4852 x127

 

[Ken Hutson]

Affirmative.
Thanks

 

[Ken Hutson]

However, opening the recordset with an SQL statement like "SELECT * FROM
TABLE" results in a recordset that does not support indexes.