limit no of records on a form

[paulevans]

HI I am creating a booking system.
I would like to have a form that only shows 10 records for each event. As this is the max number of people that can attend at any one time. How would I go about this. do I use single form, continous for or what ? thanks for any help
paul

 

[JoeCruse]

I'd start with the underlying query that your form is based on (if you're basing your forms straight from the table, you'll be better off making a query on the table and then basing your form off the query). The query allows you to limit the records returned, which show up in the form. How you limit to 10 will be based on what 10 you want. Look at the "Top Values" field in the "Properties" section of the query.