filtering records

[sunshine076]

I have done this once before but apparently I have forgotten how to do this but I do have a db with a form and I want to have it filter the none active records by having it look at the archive check button. I have attached a copy of it for your viewing

 

[SOS]

You have it right. Your query is correct. It shows no records because all of your items in the table are marked as Archive. You would then assign that query to your form.

 

[sunshine076]

If possible please refresh my memory on how to do this since I cannot remember how to. Thank you.

 

[SOS]

If possible please refresh my memory on how to do this since I cannot remember how to. Thank you.

Not sure I understand what you are asking for. The query is working just fine. The form's Record Source needs to be set to the Query. You open the form in design view, go to the properties dialog, the DATA tab and then in the dropdown for the Record Source you select the query name.

 

[sunshine076]

Is there a way to use a filter to hide archive records so that only the non-archived records will show?