Create form from dynamically built querydef

[Patrick]

I have built a dynamic querydef from a form with a series of multi-select
listboxes. I would now like to create (via code) a form based on this query
to display the summarized results of that query.

I tried pre-building the forms.. but there are 7 multi-select listboxes and
I can't see myself building a form to display the results for every
combination of selections.

I am totally open to suggestions on how to accomplish this.
Many thanks!
patrick

 

[Stefan Hoffmann]

hi Patrick,

I have built a dynamic querydef from a form with a series of multi-select
listboxes. I would now like to create (via code) a form based on this query
to display the summarized results of that query.
I am totally open to suggestions on how to accomplish this.

Just use a subform control. You can assign a query as SourceObject, so
you don't need a form.


mfG
--> stefan <--

 

[Patrick]

Thanks Stefan, that worked perfectly. The only thing I need to do now is
format the values. Since I am basing the form on the querydef I am not sure
how to do this... as different fields could be on the form each time it is
opened. Can you help?
Thanks!! patrick

 

[Stefan Hoffmann]

hi Patrick,

Thanks Stefan, that worked perfectly. The only thing I need to do now is
format the values. Since I am basing the form on the querydef I am not sure
how to do this... as different fields could be on the form each time it is
opened. Can you help?

When you assign a query, then you have not a "form". It just the same
kind of view as when you open the query in the database window.

If you need formatted values, you have to use the Format function in the
query for each field.


mfG
--> stefan <--