Select case question

[fl]

Hi,

I have created a query which outputs data to an Excel
workbook. Within the query there are 2 choices which
must be made:

Example:

There is a search form, which needs to query the
following:

(1) choose the calendar year for which the user is
reporting;
(2) from 3 comboboxes, choose three different names; the
names are chosen from the same lookup table. Each
combobox has a different reference name: cboEmpl_1,
cboEmpl_2, cboEmpl_3.

In the Excel workbook, there is a sheet, where I need to
reference cboEmpl_1, cboEmpl_2 and cboEmpl_3.

So, there is the dilemma...

any help appreciated.

 

[John Nurick]

Hi,

Can you give some more detail about your database and what you are
trying to achieve? I've added some comments below which may help

Hi,

I have created a query which outputs data to an Excel
workbook. Within the query there are 2 choices which
must be made:

Example:

There is a search form, which needs to query the
following:

(1) choose the calendar year for which the user is
reporting;
(2) from 3 comboboxes, choose three different names; the
names are chosen from the same lookup table. Each
combobox has a different reference name: cboEmpl_1,
cboEmpl_2, cboEmpl_3.

Normally you can use a parameter query that gets its parameters from the
controls on the form, using syntax like this for the parameters:

[Forms]![SearchForm]![txtCalendarYear]
[Forms]![SearchForm]![cboEmpl_1]

In the Excel workbook, there is a sheet, where I need to
reference cboEmpl_1, cboEmpl_2 and cboEmpl_3.

When you say "reference" do you mean
-you need to look up a value using the values in your comboboxes, or

-that the this sheet contains the lookup table for the comboboxes, or

-that you need to locate these values on the worksheet in order to
insert other values from your query in the correct places, or

-somthing else?

So, there is the dilemma...

Not without more information<g>

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.