Selection

[matrixindicator]

Hey,

I don't see it right now.

I have a table with values. A user should make a selection of a row and column in a combobox (a different list). The value he retrieve should be used to make a calculation in my form.
Eg. I take Column C4 on row2 and get the value 400. How to ?

ID     C1  C2  C3  C4  C5
row1   100 200 300 456 456
row2   100 200 300 400 456

 

[fneily]

If your table has a primary key, which it should, then use the Dlookup function.

 

[r937]

select C4
  from atablewithvalues
 where ID = 'row2'

r937.com | rudy.ca

 

[dhookom]

Or, you normalize your data like:

SELECT ID, "C1" as Col, [C1] as TheValue
FROM tblNoName
UNION ALL
SELECT ID, "C2", [C2]
FROM tblNoName
UNION
SELECT ID, "C3", [C3]
FROM tblNoName
UNION
SELECT ID, "C4", [C4]
FROM tblNoName
UNION
SELECT ID, "C5", [C5]
FROM tblNoName;

Then you can Select a value from [Col] from one combo box to use to filter your second combo box.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]