I have 2 form input pages and an Access Database. Using form input value from page 1, I need to create a new table in the Access database and then write to the dynamically created table using form input value from page 2. Please help...Urgent!

Thanks,
-Ted

ted

Try this code; it should create the new table and assign it the variable value as long as you have the connection to the database right:

strSQL="Create table" & " " & pgName & "(paraID COUNTER primary key, pgName Text, paraHdr Text, paraCopy Text)"

ted