hi all,

how can select a table from a range of tables in my access database using a combobox in vb6?

for example. i have list in my combobox "bank1","bank2" ,"bank3" and so on and i also have tables in my database
tbl_b1,tbl_b2,t bl_b3 etc..

if i choose bank1 from combobox, the table will change to tbl_b1 and load the data into datagrid and if i choose bank2 the table...