Referencing column in lookup cell in a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I reference a column in a lookup cell in a query

For example, in a table, I have a lookup combo box cell with four columns. I need the query to look at the data in column 4 even though column 3 is what is shown in the lookup cell

I know that in a form I can reference a column in a combo box using =[cmb_name].[Column](3) but how is that translated to reference a table cell column in a query

TI
 
Just join the table that the lookup uses and refer to the column in that
table.

Kelvin

DRiggs said:
How do I reference a column in a lookup cell in a query?

For example, in a table, I have a lookup combo box cell with four columns.
Click to expand...
I need the query to look at the data in column 4 even though column 3 is
what is shown in the lookup cell.
I know that in a form I can reference a column in a combo box using
Click to expand...
=[cmb_name].[Column](3) but how is that translated to reference a table cell
column in a query?
 
Back
Top