How to do...

R

Rodrigo Borges

I need to build a form with a list box listing all my queries (form header).
These queries are to be loaded in detail section in a spreadsheet format. I
need to use only one form... is that possible?
 
M

Mr. B

I need to build a form with a list box listing all my queries (form header).
These queries are to be loaded in detail section in a spreadsheet format. I
need to use only one form... is that possible?
Click to expand...

To display a list of queries in a list box, see the following page
form the "The Access Web" web site.

http://www.mvps.org/access/queries/qry0002.htm

As for the rest, I'm afraid I am not clear as to just what you are
trying to do.

If you can provide a little more info, I'll gald to try to help.

Are you wanting to display the results of the queries in the detail
section of a form or a report? Of perhaps I just did not get your
question.

HTH

Mr. B
 
R

Rodrigo Borges

I'm trying to display the results in details of a form... I'm not using
repots... got it? I need to select a query from the list (tks for the code)
and display the results (in spreadsheet format) in details...

tks
 
K

Klatuu

You will need a subform control in the detail section of your form. You
will need a datasheet form for each query. Once a query is selected, set
the name of the subform control's Source Object to the name of the datasheet
form associated with the query.

I would suggest that unless you really need all the query names displayed
all the time, you consider using a combo box instead. It is easier to code
for and doesn't take up as much space on the form.
 
Top