[AccessD] Which is fasted as a list control's Row Source property?

Same:
Behind the scenes Access creates a fixed query for the literal string.
You can see the hidden fixed query which is prefixed by a "~" using
following code in a form module:
    Dim dbs As DAO.Database, qdf As DAO.QueryDef
    Set dbs = CurrentDb
    For Each qdf In dbs.QueryDefs
        Debug.Print qdf.Name
    Next qdf

Asger

-----Oprindelig meddelelse-----
Fra: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] På vegne af Susan Harkins
Sendt: 1. april 2007 23:51
Til: 'Access Developers discussion and problem solving'
Emne: [AccessD] Which is fasted as a list control's Row Source property?

A literal SQL string or a fixed query? 

Susan H. 

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