Run-Time Error 3127

[poohbear2012]

I am encountering a Run-Time Error 3127, when closing a form within my database the Run-Time error states:

"The INSERT INTO statement contains the following unknown field name: 'ref_GP_Name'. Make sure you have typed the name correctly and try the operation again"

I have checked the spelling of the field name and it is correct.

The coding that I have within the VBA for the form is:

Private Sub Form_BeforeUpdate(Cancel As Integer)
If Me.Triaged = True Then
Dim db As Database
Set db = CurrentDb
db.Execute "INSERT INTO [tbldemochanges] " _
& "SELECT * FROM [tbldemography] " _
& "WHERE [tbldemography].[patient_id] =" & Me.patient_id & ";"
Set db = Nothing
Else
End If

End Sub

Any help in resolving this error would be gratefully appreciated.

 

[bob fitz]

Can you explain a little of what you are trying to do.
I don't think you can have a WHERE clause in a INSERT INTO statement.
Take a look at: http://msdn.microsoft.com/en-us/library/bb208861(v=office.12).aspx

 

[RainLover]

Why would you run a Statement like that.

If your Form was bound then there would be no need for such complications.

You don't even appear to mention the Field that you want to insert into.

 

[RainLover]

I have checked the spelling of the field name and it is correct.

How can you check the spelling. The field name mentioned in the error does not exist in your procedure.

 

[gemma-the-husky]

are you sure the field exists in tbldemochanges

maybe it has a hyphen in the field name instead of a underscore.