[dba-Tech] How to get programmatic access to lookup properties in adp tables?

Shamil Salakhetdinov shamil at users.mns.ru
Thu Oct 28 14:53:05 CDT 2004


Here is a tough one or I'm missing something obvious?

I .mdb I can write for a table's field, which has combo lookup defines:

Dim dbs As DAO.Database
Dim tdf As DAO.TableDef
Dim prp As DAO.Property
    Set dbs = CurrentDb
    Set tdf = dbs.TableDefs("tblTest")
    Set prp = tdf.Fields("F2").Properties("RowSource")
    Debug.Print prp.Value

I can't find how can I do similar thing in .adp?

TIA for any help,
Shamil




More information about the dba-Tech mailing list