Getting data from a hidden column

  • Thread starter Thread starter Eugene N. Kilmer
  • Start date Start date
E

Eugene N. Kilmer

In one of my tables, I have a lookup field that pulls 3
fields from another table. Only one field, however, is
displayed in the record. I know you can get the value of
hidden columns from a form control like a combobox, but
how do I do the same thing with a table? After I make my
recordset, I don't see how to retrieve anything from any
of the fields but the displayed value. Thanks.
 
Eugene said:
In one of my tables, I have a lookup field that pulls 3
fields from another table. Only one field, however, is
displayed in the record. I know you can get the value of
hidden columns from a form control like a combobox, but
how do I do the same thing with a table? After I make my
recordset, I don't see how to retrieve anything from any
of the fields but the displayed value.
Click to expand...


You don't do that kind of thing with a table. You should
not be displaying a table in any case so the situation
should never come up. You can however, use a query that
Joins the two tables and includes all the fields in both
tables.
 
Back
Top