Using a checkbox to filter out a specific record

[simon123]

Hi there,


I have done a lot of googling but I can't quite find what I need.

I have a multiple items form, which displays a list of outstanding enquiries. I have been asked to add a checkbox which can show/hide a particular organisation.



So basically, if you remove the check, it hides all instances of "McDonald's" in that particular field, so we can view the results with and without that particular company. Is this straightforward? And is it possible to ensure the box is checked when the form is loaded?

Thank you for your help

simon

[ranman256]

you can use a check box for 1 company, or use a combo to pick any company:

sub chkBox_Afterupdate()
   Me.Filter = "[CoName]<>'McDonalds'"
   Me.FilterOn = chkBox.value
end sub

'combo

sub cboBox_Afterupdate()
If IsNull(cboBox) Then
  Me.FilterOn = False
Else
  Me.Filter = "[CoName]<>'" & cboBox & "'"
  Me.FilterOn = True
End If
end sub

[simon123]

Brilliant, you're a superstar.

Thanks.