only show records on form which meet criteria

[tiger100]

Hello all,


I am really new to Access and stumped on how to do this. I have a table of records, and 1 of the columns is labeled "ticket status". I have created a form, but I only want the form to be able to pull records when the "ticket status" is "new". I would like to be able to navigate through all the records, via the form, for all the rows which have "new" status.

I have been able to create a combo box with the drop-down showing all the request statuses. This is difficult to use because there are thousands of records and it is showing me all the tickets (new, old, etc) which I select 1.

Is there a way to make a form which only shows "ticket status" of "new"? thanks in advance!
Bryan

[JoeM]

Sure. Just create a query that only shows records with a ticket status of "new" (via Criteria).
Then use this query as the Control Source of your Form instead of the underlying table.

[tiger100]

Thanks a bunch! I was able to get it running!