Can someone help me figure out why the following code (problem line ***ed)
is throwing the the error:
"The macro or function set to the BeforeUpdate or ValidationRule property
for this field is preventing the DB from saving the data in this field."
when this control has neither a BeforeUpdate event nor a Validation Rule
either macroed or functioned. The click event here is literally all the
code there is for this list box.
Private Sub lstAvailable_Click()
Dim strItem As String
If (lstAvailable.ItemsSelected.Count = 1) Then
lstAvailable.SetFocus
strItem = lstAvailable.Column(1)
txtAddEditAvailable.SetFocus
txtAddEditAvailable.Text = strItem
ElseIf (lstAvailable.ItemsSelected.Count > 1) Then
lblMultipleAvailable.Visible = True
End If
End Sub
Jayyde - 23 Feb 2006 21:23 GMT
lol long day...didn't star the line. It's this one that the debugger
doesn't like:
txtAddEditAvailable.Text = strItem
> Can someone help me figure out why the following code (problem line ***ed)
> is throwing the the error:
[quoted text clipped - 25 lines]
>
> End Sub