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