displaying recordsbased on a particular field

[nlgonsal]

Hi
I was wondering if you could answer a question I have since I am a first tim eSQL MS Access user. I have 4 fields in my table called date, name, type. I want to display all the recods of a certain type by having the user input the type. How can I do this ? Do I have to create a query ?
Thanks for any help
Regards
Nitin

[mist]

Originally posted by nlgonsal
Hi
I was wondering if you could answer a question I have since I am a first tim eSQL MS Access user. I have 4 fields in my table called date, name, type. I want to display all the recods of a certain type by having the user input the type. How can I do this ? Do I have to create a query ?
Thanks for any help
Regards
Nitin

Create a query in the design view, add the table and all the fields and in the criteria box below type put

[Enter the type]

in square brackets. The user will be prompted when you run the query.

[nlgonsal]

Hi
I have just leaned that the requirements for displaying the records has changed. What is needed is some kind of combobox with the different types in it, and then when one of these is clicked on, all the records with that type are displayed.
Sorry about this.
Thanks
Regards
Nitin