Query to filter bound form

[MTSPEER]

Hello guys,



I was have a question, if I have a form that's bound to a query or a table, and I have filter buttons to filter the criteria of the form. Can I write a query to select certain criteria and then have record navigational buttons to I can select every record that has that criteria? For example. I have 10 fields that have textboxes on the form and the form is bound to a table..and I have a combobox that is my filter with people's names. I want to have it so anyone can select a name and the criteria for that person shows in the textboxes, then have buttons to go the next record that has that person's criteria and to go through all of them with that person's criteria. And I have a textbox that will have the person's name that I want that is bound to the table

[ranman256]

Instead of doing ALL that programming, why not just show the user the datasheet, and let them filter on the fields THEY want.
You can write protect the data, docmd.OpenQuery qry,,acReadOnly
zero programming.

[MTSPEER]

Because I want to make it look professional looking and have it all just on the form. thanks for the response though.