E
EManning
Using SQL 2000/A2K adp. I have a table with a field called "Attended" which
is a bit field and a field called "DateAttended" which is a date field. On
the adp side, I have a continuous form with Attended as a check box (called
chkAttended). Most of the time, but not all the time, after clicking on
chkAttended, I get error message 2424 - "The expression you entered has a
field, control, or property name that IM Residents database can't find."
Sometimes, Access will end abruptly with a message that it must shut down.
The following code is in the AfterUpdate event of chkAttended:
If Me.chkAttended Then
Me.DateAttended = Me.Parent.cboConferences.Column(3)
Else
Me.DateAttended = Null
End If
If the user checks chkAttended, then DateAttended gets set to a date. If
they uncheck chkAttended, the date gets set to null.
The error points to the first line of this coding. So the problem is with
chkAttended. If I take this coding out, then you can check and uncheck
Attended all you want with no problems.
Anyone have any ideas what's wrong here? Thanks.
is a bit field and a field called "DateAttended" which is a date field. On
the adp side, I have a continuous form with Attended as a check box (called
chkAttended). Most of the time, but not all the time, after clicking on
chkAttended, I get error message 2424 - "The expression you entered has a
field, control, or property name that IM Residents database can't find."
Sometimes, Access will end abruptly with a message that it must shut down.
The following code is in the AfterUpdate event of chkAttended:
If Me.chkAttended Then
Me.DateAttended = Me.Parent.cboConferences.Column(3)
Else
Me.DateAttended = Null
End If
If the user checks chkAttended, then DateAttended gets set to a date. If
they uncheck chkAttended, the date gets set to null.
The error points to the first line of this coding. So the problem is with
chkAttended. If I take this coding out, then you can check and uncheck
Attended all you want with no problems.
Anyone have any ideas what's wrong here? Thanks.