Question about accessing various tables in Access with VB6

[GenocideOwl]

ok, I need to have three levels of data for a database. I need an overall inventory, I need where/how much of each stock is, and of each part of that stock I need info about how much came from the original order. I think I explained that right. anyway. I need to know if during an ADO command if I can use variables. like with this command

Set rs = New ADODB.Recordset 
rs.Open "TBIC", cn, adOpenKeyset, adLockPessimistic, adCmdTable

could instead of just tpying in the text TBIC, if I could use a variable name. like read what the name of the table where the item information is and then tell it to open that table.

also I was wondering how you could create a new table with the right format in VB6?

[edit] I also was wondering about about filling in information, I will have various companies that own different products. If I need to get information based on company and then product, can I set "field1" to the company and "field2" to the product then just tell it to fill the rest of the fields in?

I know I am asking a lot...