Allow a specific amount of records in a Subform.

[rogerarce]

I have a form for an invoice an a subform for the records of
the invoice. I would like to know if I can restric the
amount of input record. Let's say I only wnat my invoice
to have a max of 10 items.
I hope someone can help. Thanks in advance:

 

[BoxHead]

Look at the TOP predicate in Access Help. It allows you to restrict the results of a select query to the Top n records. You may have to modify the ORDER BY clause of your query to return the desired ten records.

HTH John

Use what you have,
Learn what you can,
Create what you need.

 

[jgoodman00]

You could try using SELECT TOP 10 (assuming all records are numbered) as the recordsource for your subform. This should then select the top 10 related records to be displayed in your subform... James Goodman