Mutiple options using combo boxes

mercury

Registered User.
Local time
Today, 00:46
Joined
Jul 17, 2004
Messages
35
Hi guys

I need some help.I would like to know if anyone has a solution to my problem im using Microsoft 2000 and i would greatly appreciate it if someone have any ideas on what i could do.This is how it goes...........

When a item is selected from three combo boxes the 3 selections would become 1 choice. Example: Say from cbo 1 select FLT , cbo 2 select BF, cbo 3 select 0
this would come together to make a choice of FLTBF0 which means a customer wants a flat-top bifocal lens at zero difficulty, this is just an example and this cobination would have a cost attached to it .

The problem is that i do not want to put all of these cobinations into
code because they are so many combination that could be selected. Also when a seletion is made the user still has an additional 2 combo boxes in which to select choices which would add additional cost to the final total.

I would like to know if anyone has any sugestions?

Thank you very much
Mercury
 
Mercury,

ProductName = Me.cbo1 & Me.cbo2 & Me.cbo3

Then, you can look up the DLookUp function to get the cost.

Wayne
 
Thanks alot ill give that a try
 
hi again

i tried the Dlookup and it worked
thanks alot

mercury
 

Users who are viewing this thread

Back
Top Bottom