Simulating recordsource property of datacontrol Dynamically

In the DataControl provided by microsoft, when you provide the database name, the recordsource property in Property sheet gets populated dynamically with the list of tables available in that database.
how do i simulate the above behaviour dynamically in my own control.

Remarks - Using ENUM i can statically provide a list of values which appear in my userdefined property in the property sheet of my control and i can select any one value.

I want to do this dynamically.