Can I create 30 unique instances from 1 subform.

[ions]

Dear MSAccess Expert.

I need 30 instances of a subform within a parent form.

The only difference between each subform instance will be one parameter(criteria) in the subforms's underlying query.

The user wants to look at 30 different parameter details simultaneously on one form.

Instead of creating 30 unique subforms how can I program this so I only use 1 subform 30 times. Sort of like Object Oriented Programming.

Thank you.

Note: I am aware that the conventional way of doing this is to have one Subform and allow the user to change one parameter. However, the user wants to look at multiple parameters simultaneously.

Thank you.

Peter

 

[boblarson]

Sorry, if you want them to be there at the same time, I'm afraid you will need to put it on there 30 times.

 

[gemma-the-husky]

why not just one form with 30 items on it - they cant all be from different tables, surely, so base it on a query including whatever fields you need

even if they are on 30 different tables, just do 30 dlookups

 

[boblarson]

just do 30 dlookups

Boy that would sure be potentially a very, very slow way to go

 

[ions]

Is the concesus that I have to make 30 forms? I don't understand the lookup example.

 

[boblarson]

Boy that would sure be potentially a very, very slow way to go

Although I imagine 30 subforms can also be potentially very, very slow.

 

[gemma-the-husky]

Boy that would sure be potentially a very, very slow way to go

not really - definitely quicker than 30 subforms!

I have an app where the users want to see some daily stats - its a transport company, so its numbers of drivers , drivers on , drivers off, vehicles used, not used, hours worked, overtime, total packages moved etc

there are a number of base queries, and probably about 30 lookups based no these, spread over 5 or 6 tab pages, and then some percentages etc.

the form opens virtually instantly.

 

[ions]

Bob and larson I also have a query question if you would like to take a stab at that.

http://www.access-programmers.co.uk/forums/showthread.php?p=825264#post825264

Thanks.

 

[boblarson]

Bob and larson I also have a query question if you would like to take a stab at that.

http://www.access-programmers.co.uk/forums/showthread.php?p=825264#post825264

That one is outside my range of experience. Hopefully someone else can help there. I haven't used the TOP functionality except in a very rare instance and not like you want here.

 

[ions]

Thank you both, Husky and Boblarson.

Very good feedback.

Again Thanks very much.