Select all only where conditions is met

[webisti]

Hi I have the following code:

Private Sub Sselect_all_Click()
Set rstBUYList = Me.RecordsetClone
If rstBUYList.RecordCount <> 0 Then
rstBUYList.MoveFirst
Do While Not rstBUYList.EOF
With rstBUYList
.Edit
If IsNull(!FLAGED_BY) Then
!SEND_MAIL = True
!FLAGED_BY = fOSUserName()
End If


.Update
End With
rstBUYList.MoveNext
Loop
End If
Me.Requery
End Sub

So far everything eorks fine. But I got to change it. I have this button that says select all, and the above code does it.
What I need is to select only those where a control condition is met
: smth like : select all where order is null.
how could I add that in the code...I tried some versions but it did not worked...
any ideas?

Webisti

[June7]

Your code already shows conditional structure. If you have more criteria then expand the If Then condition to include them.