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

That's because ADPs don't have any MDB tables or access to any such things.
No linked tables of any kind.  Since DAO only works with the MDB tables, it
doesn't exist in an adp.

John W. Colby
www.ColbyConsulting.com 

Contribute your unused CPU cycles to a good cause:
http://folding.stanford.edu/

-----Original Message-----
From: dba-tech-bounces at databaseadvisors.com
[mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Shamil
Salakhetdinov
Sent: Thursday, October 28, 2004 3:53 PM
To: DBA-Tech
Subject: [dba-Tech] How to get programmatic access to lookup properties
inadp tables?
Importance: High


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

_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com