Lookup $ Amounts based on multiple Combo Boxes

G

Guest

I have 3 combo boxes and a text box on a form. I want to lookup a dollar
amount from a table based on the three combo box values. So for example. I
have a table, I'll call "ResourceCosts" that has numeric value fields a,b,c
and dollar amount d. On my form, I have combo box 1,2,3 and text box 4. I
want to look up the dollar amount (d) in table "ResourceCosts" where combo
box 1 = field a in ResourceCosts and combo box 2 = field b and combo box 3 =
field c in resources costs and store the dollar amount in the text box 4 on
the form. Any help would be greatly appreciated.
 

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

Similar Threads

Lookup value based on multiple combo boxes 1
Query based on combo box values 2
Combo Box help 0
Filter combo box based on another unrelated combo box 1
Update Textbox based on Selection from Multiple Comboboxes 1
How to switch combo boxes? 1
Data for Combo Boxes - Most efficient method? 4
Using combo box when adding records to continuous form 1

Top