Hi all. I'm trying to execute an sql query with variables, but it won't work. Code is below.
DoCmd.RunSQL "INSERT INTO Students ([Student ID], [Student Name], [House]) VALUES (" & TempID & ", " & TempName & ", " & TempHouse & ")"
The TempName and TempHouse won't work and parameter value boxes appear.
DoCmd.RunSQL "INSERT INTO Students ([Student ID], [Student Name], [House]) VALUES (" & TempID & ", " & TempName & ", " & TempHouse & ")"
The TempName and TempHouse won't work and parameter value boxes appear.