Get Table Names from a Recordsource without refreshing...

Is it possible to get the Table names without invoking a data1.refresh when I change the DatabaseName and/or Recordsource.

Thanks