Select /Deselect checkboxes

[Mario]

Hi

In a continious form I have a checkbox named OK.
As I can filter the records by date and only show the records for a
particular date , I'd like to automaticly select or deselect the checkbox
for all records filtered.

Is there a way to do this ?
Thanks for replying

Mario

 

[Mario]

Alan

thanks a lot
Mario

Use an Update query limited to the same conditions as the form's filter:

Dim strSQL As String

If Me.FilterOn Then
If Me.Dirty Then 'Save any changes
Me.Dirty = False
End If
strSQL = "UPDATE MyTable SET [OK] = True WHERE " & Me.Filter & ";"
dbEngine(0)(0).Execute strSQL, dbFailOnError
Me.Requery
Else
beep
End If

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to the newsgroup. (Email address has spurious "_SpamTrap")

Hi

In a continious form I have a checkbox named OK.
As I can filter the records by date and only show the records for a
particular date , I'd like to automaticly select or deselect the checkbox
for all records filtered.

Is there a way to do this ?
Thanks for replying

Mario