Disable recordset if check box true

[ghost]

Greeting,

I have a continues form has three fields, ID, name and check box. What I
want to do is once user mark the check box, the record set is invisible and
others records stay visible. I try to make that by using the following code
but all ID records are invisible.

Private Sub Form_AfterUpdate()

If Me.Checkbox = True Then
Me.ID = False
Else
Me.ID = True
End If
End Sub

 

[Wayne-I-M]

Hi

On a continous form whatever attributes you set one record will affect all
the record attibutes

As an example if you use Me.AllowEdits = False this would lock the whole
form.

A continous form is "one" form" with lots of records. There are ways around
this like using a small "well placed" popup to simulate the top row of a
continous form, etc.