Form Error Message

[Andy Roberts]

I have two cbo boxes set up with the second being filtered by the selected
value in the first with a query running in the second cbo based on the first
and a requery set up on the after_update event of the first cbo

However, I keep getting an error which says "Cant set Value to NULL when
Checkbox property = FALSE"

Don't know what this is? Any Ideas?


Andy

 

[Douglas J. Steele]

What's the code that's generating the error?

 

[Andy Roberts]

The after update event on the first cbo is

Private Sub cboWatercourse_AfterUpdate()
Me!cboReach.Requery
End Sub

The query on the second cbo is :

SELECT tblReach.ReachID, tblReach.ReachName, tblReach.ReachNo,
tblReach.WatercourseID FROM tblWatercourse INNER JOIN tblReach ON
tblWatercourse.WatercourseID=tblReach.WatercourseID WHERE
(((tblReach.WatercourseID)=Forms!frmInput!cboWatercourse)) ORDER BY
tblReach.ReachName;

Andy

 

[Douglas J. Steele]

Try single-stepping through your code to see what line is actually raising
the error.

Based on what you've shown below, I think it's coincidence that it happens
with your Requery statement.