looking up values


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
 
Ad

Advertisements

J

Jeff Boyce

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

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