Hello,
I'm getting an error telling me that "You can't assign a value to
this object" whenever I try to assign values to a checkbox. My Code is
below. Any ideas? I have the values assigned as true and false in this
code, but I have tried with 0 and 1 and have received the same error.
------------------------------------------------------------------------------------------------------------------------------------
Private Sub List372_BeforeUpdate(Cancel As Integer)
ErrorID = List372.Column(0)
ErrorCategory = List372.Column(1)
ErrorType = List372.Column(2)
ErrorDetail = List372.Column(3)
ErrorDate = List372.Column(4)
Call DBConnect
sql = "SELECT
ERRORID,ERRORCATEGORY,ERRORTYPE,ERRORDETAIL,ERRORDESCRIPTION,ERRORDATE,RESPONSIBLEPARTY,ERRORRESOLVED
FROM " & tblErrors & " WHERE ERRORID = '" & ErrorID & "'"
rsdata.Open (sql)
Text380.Value = rsdata("ERRORCATEGORY")
Text382.Value = rsdata("ERRORTYPE")
Text384.Value = rsdata("ERRORDETAIL")
Text386.Value = rsdata("ERRORDESCRIPTION")
Text390.Value = rsdata("ERRORDATE")
Combo505.Value = rsdata("RESPONSIBLEPARTY")
If rsdata("ERRORRESOLVED") = 1 Then
Check392.Value = True
ElseIf rsdata("ERRORRESOLVED") = O Then
Check392.Value = False
End If
rsdata.Close
End Sub
----------------------------------------------------------------------------------------------------------
Ed Metcalfe - 03 May 2007 23:58 GMT
> Hello,
>
[quoted text clipped - 35 lines]
> End Sub
> ----------------------------------------------------------------------------------------------------------
I assume the errors are occurring here:
Check392.Value = True
Check392.Value = False
If so I can't see anything wrong with what you are trying to do. Are you
sure these control is an Access checkbox? Try running the following check in
the immediate window:
?typeof forms!form1!check392 is Access.CheckBox
Ed Metcalfe.
Trepalium@gmail.com - 04 May 2007 20:44 GMT
> <Trepal...@gmail.com> wrote in message
>
[quoted text clipped - 53 lines]
>
> - Show quoted text -
I figured out why it wasn't working. They were bound for some
reason... Access automatically binds a checkbox when you put it on a
tab. That stinks.
ThomCarr - 11 May 2007 20:46 GMT
On May 4, 3:44 pm, Trepal...@gmail.com wrote:
> > <Trepal...@gmail.com> wrote in message
>
[quoted text clipped - 59 lines]
>
> - Show quoted text -
Are updating the table directly?