Create form from dynamically built querydef

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
Click to expand...
Just use a subform control. You can assign a query as SourceObject, so
you don't need a form.


mfG
--> stefan <--
 
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
 
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?
Click to expand...
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 <--
 
Back
Top