I use the following instructions to attach to an
Access database table using ADO and the Data environment:

DataEnvironment1.phone1
Set rs = DataEnvironment1.rsPhone1

How can I change "Phone1" in these instructions or build these instructions at runtime to reflect a different table name(the table name is being selected from a long list of table names at runtime)

Thanks---Tennisnet