INSERT INTO ClassAndUnit (ClassID, UnitID)
VALUES (#form.ClassID#, #form.UnitID1#)
WHERE (((ClassAndUnit.ClassID)=#form.ClassID#) AND ((ClassAndUnit.UnitID)=#form.UnitID1#));

i have this for my code n its just giving an error missing semicolon at the end of the sql statement. ive tried putting the semicolon everywhere, but its just not working.

Where are you using this SQL?
Is this the argument to a <connection>.Execute statement?
Is this the text of a named query?

What does “form” refer to in “#form.ClassID#” (et al.)?
I’m not familiar with the use you’re making of pound signs (“#”). I thought their purpose was to delimit dates, but it appears from this context that they can be used to get SQL in a form’s module to extract data from the form; Is that correct?

Brian poses good questions. What is this #form.ClassID# structure? It doesn't look familiar. If you're using the DoCmd.RunSQL method with fields from the active form, it should look something like this:

DoCmd.RunSQL "INSERT INTO ClassAndUnit (ClassID, UnitID) VALUES (" & Me.ClassID & ", " & Me.UnitID1 & " WHERE (((ClassAndUnit.ClassID) = " & Me.ClassID & " AND ((ClassAndUnit.UnitID) = " & Me.UnitID1 & "));"

if the IDs are numbers or

DoCmd.RunSQL "INSERT INTO ClassAndUnit (ClassID, UnitID) VALUES (" & Me.ClassID & ", " & Me.UnitID1 & " WHERE (((ClassAndUnit.ClassID) = '" & Me.ClassID & "' AND ((ClassAndUnit.UnitID) = '" & Me.UnitID1 & "'));"

if the IDs are text.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division