M
Marc Meltzer
I have a form with six controls (text box and some combo boxes). I want
to insert their values into a table. For the combo boxes, the first
column is a number, the second column is the associated text that is
chosen on the form. I want to insert the numbers into the destination
table. Please help me figure out what my query should look like,
because it won't run as currently written.
strSQL1 = "INSERT INTO TBL_Albums (Album_Title, Format_Num, " & _
"Genre_Num, Artist_Num, Label_Num, Year_Num) " & _
"VALUES ([Forms]![FRM_Add_Album]![Album_Title], " & _
"[Forms]![FRM_Add_Album]![Album_Format.Column(0)], " & _
"[Forms]![FRM_Add_Album]![Album_Genre.Column(0)], " & _
[Forms]![FRM_Add_Album]![Album_Artist.Column(0)], " & _
[Forms]![FRM_Add_Album]![Album_Label.Column(0)], " & _
[Forms]![FRM_Add_Album]![Album_Year.Column(0)]);"
Access is telling me the bracketing is invalid. I've tried adding and
removing them in multiple locations, but nothing I try seems to work.
Thanks in advance!
Marc
to insert their values into a table. For the combo boxes, the first
column is a number, the second column is the associated text that is
chosen on the form. I want to insert the numbers into the destination
table. Please help me figure out what my query should look like,
because it won't run as currently written.
strSQL1 = "INSERT INTO TBL_Albums (Album_Title, Format_Num, " & _
"Genre_Num, Artist_Num, Label_Num, Year_Num) " & _
"VALUES ([Forms]![FRM_Add_Album]![Album_Title], " & _
"[Forms]![FRM_Add_Album]![Album_Format.Column(0)], " & _
"[Forms]![FRM_Add_Album]![Album_Genre.Column(0)], " & _
[Forms]![FRM_Add_Album]![Album_Artist.Column(0)], " & _
[Forms]![FRM_Add_Album]![Album_Label.Column(0)], " & _
[Forms]![FRM_Add_Album]![Album_Year.Column(0)]);"
Access is telling me the bracketing is invalid. I've tried adding and
removing them in multiple locations, but nothing I try seems to work.
Thanks in advance!
Marc