Can I filter a form?

[Certified]

I have a data base with about 1000 records.

I created a form with 4 check books. Each check box value if based on criteria displayed on the Form. For instance, if Field 1 and Field 5 contains values over 50%, then the check box is true.

I was wondering is there a way I can filter the form just to display items that are checked?

Hope this makes sense.

 

[My Aswer Is This]

I wish people using this forum used better terminology. When you say you have a "Form".
What is a "Form"

Some people when they say "Form" they mean a "Sheet"
Others mean a "Table"
Others mean a "UserForm"
Others mean a "DataForm"
Normally fields refer to "Tables"

I'm not aware of assigning checkboxes to a "Table"

Maybe you could explain to me what you mean when you say "Form"

 

[Certified]

I am new to access so I am not aware of all of terminology.

I guess it is a sheet. When I select properties it reads "Property Sheet"

I used the term form because that is what I created when I used them Form Wizard.

I wish people using this forum used better terminology. When you say you have a "Form".
What is a "Form"

Some people when they say "Form" they mean a "Sheet"
Others mean a "Table"
Others mean a "UserForm"
Others mean a "DataForm"
Normally fields refer to "Tables"

I'm not aware of assigning checkboxes to a "Table"

Maybe you could explain to me what you mean when you say "Form"

 

[My Aswer Is This]

I'm sorry. I now notice this is not a Excel Question. I'm not able to help with Access questions.

I am new to access so I am not aware of all of terminology.

I guess it is a sheet. When I select properties it reads "Property Sheet"

I used the term form because that is what I created when I used them Form Wizard.

 

[Norie]

Certified

Do you want to filter the data the form shows based on which checkboxes are checked/unchecked?

Which field(s) do you want to filter on?

 

[Certified]

Yes, I want the form only show data with a checkbox checked.

Certified

Do you want to filter the data the form shows based on which checkboxes are checked/unchecked?

Which field(s) do you want to filter on?