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

 

[missinglinq]

I don't think there's any way for anyone to help you with this unless we can see the code you're having the problem with. Either zip and attach the database file (also tell us what version you're running) or the the code itself.

 

[Adigga1]

I don't think there's any way for anyone to help you with this unless we can see the code you're having the problem with. Either zip and attach the database file (also tell us what version you're running) or the the code itself.

Thank you for pointing out my mis-steps, I have updated my original post.

Thanks in advance.


A....