Create MS Access Table using VBA

Hello,

I'm trying to create a MS Access Table using VBA through a form...

The form has a combo box called cboCategory and a list-box called lstDrugs.

I want to create a table where the name of the tbl appears as "tbl + cboCategory.value + Date" and add an ID field followed by the drugs selected as the column names...

How can I accomplish that? I started on the code below, but not sure how it would work

Please Login or Register  to view this content.

Thanks for the reply ExlGuru. I'll checkout this link and then tell you about the result.