Limit the number of records in a form

[AppleEater]

I hope someone will be able to help me with this one. I use most of Access capabilities except for vba that I do not master actually. So here is my question : What is the easiest way to limit the number of records in a form or subform ? For example, for one client you want to limit to 5 the number of demands he can do.
Thanks !

 

[Sohaila Taravati]

The only thing I can think of is in your query put a critaria. For example: If it's date you can limit what dates to show, or if it's numbers you can also limit the number of records to show. You have to elaborate a little bit more for me to be able to answer your question.

Sohaila

 

[AppleEater]

It's pretty simple actually. I have a form where clients enter their name and other data and a subform where they can enter demands and other information. Each demand must be a different record because each one has its particularities. But, we want to limit the number of demands one client can enter into our system to five or another limited number. Two tables with a one-to-many link, T_Clients and T_Demands, each one having an autonumber field as primary key.
The thing is I don't see how I can set a criteria to say : I want 5 records, that's all !!!
I hope I have given the necessary info. Thank you for your quick answer !

 

[AppleEater]

The same thing would be applicable for a report...

 

[Sohaila Taravati]

Refer to this posting, it might answer your question: http://www.access-programmers.co.uk/ubb/Forum1/HTML/007034.html

 

[AppleEater]

Great ! That should do the thing.

Ciao !