looking up values

  • Thread starter Thread starter accidental
  • Start date Start date
A

accidental

I have setup two combo box fields with list value row
sources equal to the Row (EE, ES, EC, EF) values and
Column Headings (HS, HL, MC).

Here is the Table I want to lookup from:

CH HS HL MC
EE 25 22 34
ES 58 53 81
EC 45 41 63
EF 72 65 99

How do I have Access lookup a value based on these two
inputs and display it?

TIA
 
Consider changing the table design to something like:

tlkpUnknownTable
YourRowHeader
YourColumnHeader
YourValue

so the data would look like:

EE; HS; 25
EE; HL; 22
EE; MC; 34
ES; HS; 58
...

Now your two combo boxes can refer to the first and second columns. Your
first combo box limits to all rows with, say "EE", and the second allows
selection of, say "MC", to derive "34".
 
Back
Top