Hi Everyone,
Sorry to be bothering you again so soon, VB is turning out to be more complicated than I thought.
Basically, I keep getting syntax errors for my INSERT INTO code (I'm trying to save data from a form into a table). I've looked through a few different discussions and Access help pages, but the format doesn't seem to be working for me. Could anyone let me know what I'm doing wrong?
Private Sub Submit_button_Click()
DoCmd.RunSQL "INSERT INTO [Record_Keeper](Employee_Name,Specific_Task,Hours,Region)
VALUES([Forms!Layout!Name], [Forms!Layout!Specific_Combo], [Forms!Layout!Text11], [Forms!Layout!Combo14]);"
Thanks in advance,
Tiffany