How do i make a button that will go to a specific record?

[TOMMY.MYERS668]

Ok, first off I'm not the brightest with Access and its been forever since I've used it. I have a database that tracks all the classes that my unit teaches and have querys to tell me which classes dont have enough instructors or which instructors dont have orders. there will be over 600 courses in the database so I need a button that will allow you to goto a specific record. so if the query says record 198 needs an instructor I would like to be able to put 198 in a box and hit a button that will take me stright to that record in the form window. Any ideas?

[June7]

Several ways to do this.

1. use intrinsic Access sort/filter tools from ribbon and shortcut menu

2. use code (VBA or macro)
a. set filter property of form
b. modify form record source
c. parameterized query - review http://datapigtechnologies.com/flash...tomfilter.html

[TOMMY.MYERS668]

ty ill get right on the code