Select /Deselect checkboxes

  • Thread starter Thread starter Mario
  • Start date Start date
M

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
 
Alan

thanks a lot
Mario
Allen Browne said:
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")

Mario said:
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
Click to expand...
Click to expand...
 
Back
Top