Database(ADODB)

[mclueless]

I m working with VB6 & Access. I am connecting my forms to the database using ADODB connection. what i want to know is in my form there is a field to be filled upon by the user. based upon that value which table from the entire database should be dealt with is decided. how do i do this?

[debasisdas]

You just need to pass the value to recordset open method dynamically.