Displaying a set amount of records in a form

[SMatthews]

I have a form based on a query and I want the form to show me the first ten records that match the criteria of the query. Is there a way to do this?

On a similar note, if I am able to have the form show the first ten records, can I have the form prompt the user for his/her name and have the user's name appeneded to each of the records?

Thanks in advance.

 

[Fizzio]

In the Query design grid, bring up the properties box of the query and set the top values setting to 10. this will bring up the first 10 but be aware if you have a sort order in your query, it will bring in the first 10 sorted values.
If you want to display all 10 at once, set up a continuous form big enough to contain all 10 records.
HTH