Filtering Forms

[andrew46]

Hello,

I am pretty new to access and don't really know much about it. I just made up a basic table and form. I want to be able to filter the form so once I mark a field which has a checkbox, that form disappears, and only the forms that are not checked are left. Does anyone know how to do this? I know there is a way as I have seen it working in a database but I just don't know how to do it myself!

Cheers

Andrew

 

[bat17]

You will need to use a query for the form, then in the field that you have the check box set the criteria to False.

You may alos want to add a requery to the field in the form to autoaticaly hide the record.

in the AfterUpdate event for the field add Me.requery

HTh

Peter

 

[andrew46]

Thanks!

The first bit helped heaps. I don't quite understand the 2nd bit though. What is the after update event bit????

 

[bat17]

In design mode of the Form got to the properties for your control and there is one under events called "After Update", this runs the code whenever the value of that field changes.
If you hit the build button and select code, the code pane will open up ready for code, just add the line above and you should end up with something like

Private Sub MyField_AfterUpdate()
      Me.requery 
End Sub

This will cause Access to requry the form if you click the check box and hide the record that you have just selected.
Whether you will actualy need this depends on what you are doing.

Just try it and see

Peter