Quering from two sides

[Fenrir]

I have a table with the columns and the rows both as parmeters for a query. I know it's probably brain freeze but I can't figure out how to do it using only one statement.

Example

- a b c d
1 5 3 2 6
2 2 4 5 0
3 5 6 7 3

The user inputs both the row variable and the column variable and I need to dig out data that corresponds to.

Example input 2,b would yield 4 and 3,c would yield 7

Any ideas using only one form? I can't use other forms as I normally would to have the user specify either the row or the column.

Thanks in advance!

 

[Jon K]

You can use the DLookup() function to look up the values.

See database attached. The code used is in the After Update event of the two combo boxes on the form.
.

 

[Fenrir]

Thank you Jon K!