ERROR: "enter parameter value"

[adigga1]

Hello EveryOne,

I have a situation with a Form running an event; It works fine when it calls or manipulates number values; but when I put a character within the numbers or use alpha-numeric values, I get this error "enter parameter value" when i press my click action button with the alphanumeric value as the problem..

Please assist, I searched the entire forum and the net for answers, but nothin.

A......

I apologize for the inconvenience: Here is the code

Private Sub cmdAddDonor_Click()
Dim strSQL As String
strSQL = "INSERT INTO T_Patient_Donor ([Patient_ID], [Donor_ID]) VALUES (" & Patient.Value & ", " & DonorID.Value & ");"
 DoCmd.SetWarnings True
DoCmd.RunSQL (strSQL)
 DoCmd.SetWarnings True
MsgBox ("Donor has been added")
DoCmd.Close acForm, Me.Name
Forms!F_PatientCase2.DonorNum.SetFocus
 Forms!F_PatientCase2.DonorNum.Requery
End Sub

[ChipR]

What data types are the fields you are trying to insert into?

[adigga1]

@ChipR
the data type is text or would you like me to check other attributes?

[ChipR]

Text values require delimiters around them in SQL. Like this:

strSQL = "INSERT INTO T_Patient_Donor ([Patient_ID], [Donor_ID]) VALUES ('" & Patient.Value & "', '" & DonorID.Value & "');"

[adigga1]

@ChipR

Thank you ChipR for your response and suggestion; i will give this a shot and give status update.

Thanks again

A...

[adigga1]

@ChipR

ChipR, Thanks again for the edit; it works great; but I have one other question:

I now recieve this message " You are about to append 1 row(s)" confirmation message; I press "yes" then the code runs fine after that.

how to stop this message from showing? just run the code?

Thanks again

A...

[ChipR]

You can use "DoCmd.SetWarnings False" but make sure to always use "DoCmd.SetWarnings True" afterwards.

[adigga1]

@ChipR
Thank you again for all of your time, patience and assistance with this issue.

It works perfectly!!!! :-)

Regards,

A....