Parameter values in report

P

Panda

Hi everyone,

I'm doing up an order database that uses a report to display orders that are
faxed to the supplier.

When the report is first opened, it asks the user for the name of the
supplier (to print at the top and specify which orders to display), the date
(to also specify which orders to display), and the customer number (for the
benefit of the supplier).

Now, there are two main suppliers for this business, other suppliers are
used every now and then. Because of this, if one of these two main suppliers
is entered as a parameter initially, the corresponding customer number I
hard-code in should be displayed without having to ask the user for it. If,
however, another supplier is entered, it should ask the user for the customer
number.

This is all done in a label on the report. Currently, its control source is
set to this:
=IIf([Supplier]="supplier1","Customer
#123456",(IIf([Supplier]="supplier2","Customer #987654","Customer #" &
[Please enter customer number:])))
This works, but asks for the customer number regardless of the supplier I
enter initially.

I'm looking for a way to do something similar to above, but it shouldn't ask
for the customer number if I enter "supplier1" or "supplier2", it should use
my hard-coded values.
Any help would be much appreciated!

Thanks,
Panda.
- - - - -
Win XP Pro
Access 2003
 
P

Panda

It would be really good to get some help with this, I need to figure this out
ASAP. Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top