Have not used Access in 3 years - help

[aftershokk]

I have a form which opens in datasheet view with over 3k rows.
I have a field named type which lists each member's type code.

Example 500 customers can be coded as better, 200 as good etc.

When the user opens the form, I want a prompt to allow the user to select these values from a list which is distinct and then filter the results based on the selection of the user.

I really forget how to do this.

help

 

[KeithG]

use a parameter in the record source of you form.

 

[aftershokk]

more help please

I have not used Access in 3 years so I will need more info.

I can create a prompt qry that asks the user to key in the value. THey want more than this. The user would like to see the values and just click on the ones that want.

thanks