Hi kids. I've been staring at this for 2 days trying to figure out why I get the "Method or data member not found" error. I think it's time to let you guys look at it. I'm sure it's something dumb that I can't see for the trees.
Private Sub Command901_Click()
Dim CLAIM_NUMBER, SURNAME, FIRST_NAME, DATE_OF_BIRTH, GENDER As String
Dim strSQLApp As String
CLAIM_NUMBER = Me.HIC_CLAIM_NUMBER
SURNAME = Me.LAST_FULL_NAME
FIRST_NAME = Me.FIRST_FULL_NAME
DATE_OF_BIRTH = Me.BIRTHDATE
GENDER = Me.GENDER
strSQLApp = "INSERT INTO PBP_TRANSACTION_TABLE (CLAIM_NUMBER, SURNAME, FIRST_NAME, DATE_OF_BIRTH, GENDER) VALUES ('" & HIC_CLAIM_NUMBER & "', '" & LAST_FULL_NAME & "','" & FIRST_FULL_NAME & "', '" & BIRTHDATE & "', '" & GENDER & "')"
DoCmd.RunSQL strSQLApp
MsgBox "The Record has been Processed."
End Sub
Private Sub Command901_Click()
Dim CLAIM_NUMBER, SURNAME, FIRST_NAME, DATE_OF_BIRTH, GENDER As String
Dim strSQLApp As String
CLAIM_NUMBER = Me.HIC_CLAIM_NUMBER
SURNAME = Me.LAST_FULL_NAME
FIRST_NAME = Me.FIRST_FULL_NAME
DATE_OF_BIRTH = Me.BIRTHDATE
GENDER = Me.GENDER
strSQLApp = "INSERT INTO PBP_TRANSACTION_TABLE (CLAIM_NUMBER, SURNAME, FIRST_NAME, DATE_OF_BIRTH, GENDER) VALUES ('" & HIC_CLAIM_NUMBER & "', '" & LAST_FULL_NAME & "','" & FIRST_FULL_NAME & "', '" & BIRTHDATE & "', '" & GENDER & "')"
DoCmd.RunSQL strSQLApp
MsgBox "The Record has been Processed."
End Sub