I have a database that asks the user for many inputs and stores them in variables. From these variables a table name is created. Like so:
Expand|Select|Wrap|Line Numbers
- 'Specify table name
- Set tbl = dbs.CreateTableDef(userCircuit & "-" & userStart & "," & userEnd)
Expand|Select|Wrap|Line Numbers
- DoCmd.RunSQL ("INSERT INTO Table1 ([Field1])VALUES(Cable_Start)")
My most current attempt I saved the 3 seperate variables into one string variable, so I end up with:
Expand|Select|Wrap|Line Numbers
- DoCmd.RunSQL ("INSERT INTO tableName([Field1])VALUES(Cable_Start)")
Seth