Choose tbl defined by Paremeter
Posted on 2009-02-24
I have a form in VB6 which contains my grid, I have 2 tables in my database with different results.
I want to know of it's possible to have the table name as a parameter, which I can specify from VB6. I know how to specify the parameter and how to make it work.
But I don't know If the parameter can be the table name.
For example, I call my qry_XYZ, which takes tbl_A by as coded in the query. Can I have tbl_A as a parameter, which I can define from my VB6 combo box, so if the user selects tbl_B, then it should call tbl_b in qry_XYZ