HI,
Can someone please tell me how to write the following in VB - using all the right syntax. I am using DAO and i cant make it work. I'm getting syntax errors


"Insert into
" & _
"VALUES (w,x, y,z)" &_
Where:
1. x is a string that the user types into a text box on a form
2. y is a string that the user selects from a combo box
3. z is a string that the user selects from a combo box
4. w is an integer that represents the last table index+1
(i.e. if the table has 51 records currently, the value for w after adding a new record to this table is 52)
PLEASE help...
Bella

Can someone please tell me how to write the following in VB - using all the right syntax. I am using DAO and i cant make it work. I'm getting syntax errors



"Insert into
"VALUES (w,x, y,z)" &_
Where:
1. x is a string that the user types into a text box on a form
2. y is a string that the user selects from a combo box
3. z is a string that the user selects from a combo box
4. w is an integer that represents the last table index+1
(i.e. if the table has 51 records currently, the value for w after adding a new record to this table is 52)
PLEASE help...
Bella
