G
gmazza via AccessMonster.com
Hi there,
I keep getting this error on my form.
I have an unbound combo box that selects certain values to fill the combo box.
When a choice is made to the combo box, in the On Change Event of the combo
box I have the following code:
Dim ssql As String
ssql = "Update PatientData " & _
"Set Value1 = '" & combo1 & "', " & _
"ModifierDate = '" & TimeAndDate & "', " & _
"ModifierID = '" & ap_GetUserName & "' " & _
"where ClinicalTrialId = " & GetActiveStudy & ";"
CurrentDb.Execute ssql, dbFailOnError
When a choice is made in the combo box it updates fine. Whenever a 2nd choice
is made to the same combo box, just choosing a different value, I get this
message.
Any ideas?
I keep getting this error on my form.
I have an unbound combo box that selects certain values to fill the combo box.
When a choice is made to the combo box, in the On Change Event of the combo
box I have the following code:
Dim ssql As String
ssql = "Update PatientData " & _
"Set Value1 = '" & combo1 & "', " & _
"ModifierDate = '" & TimeAndDate & "', " & _
"ModifierID = '" & ap_GetUserName & "' " & _
"where ClinicalTrialId = " & GetActiveStudy & ";"
CurrentDb.Execute ssql, dbFailOnError
When a choice is made in the combo box it updates fine. Whenever a 2nd choice
is made to the same combo box, just choosing a different value, I get this
message.
Any ideas?