Select case question

  • Thread starter Thread starter fl
  • Start date Start date
F

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.
 
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.
 
Back
Top