List box display based on check box selections

[advantor]

I am just starting to learn access and about databases so please forgive any ignorance.
I have a very simple document database that I have created. That I am using to organize and track documents with. I want to be able to archive old revisions of documents and only want to display document that are not marked as archived. I have a field in my table that show if the document is archived or active. How can I make my list show only the active documents?
I have a control button that I wish to use to enable the viewing of the archived documents.

I then also want to be ablt to select a check box and have my list box view be filtered. I basically want to have it so when I select the check box that it filters the view by searching the decription field and only showing relevent items.

 

[randy700]

Base you list on a query. In the query you can use a WHERE clause to display the records you want.


Randy

 

[missinglinq]

Something like this, to show documents not marked as
'Archived.'

SELECT DocumentsTable.DocumentID, DocumentsTable.DocumentName, DocumentsTable.Archived
FROM DocumentsTable
WHERE (((DocumentsTable.Archived)=0));

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!