Lookup Problem

[Guest]

Okay, this might be a stupid question, but here goes. How come in a form, the
values in lookup fields aren't the same as they are in table view?

For example, table B has information from table A in several lookup fields.
When I look at table, the value shows fine, but if I create a form for that
table, it shows the id of the value, not the value itself.

 

[Pieter Wijnen]

use queries to link the tables to display on the form, the Lookup feature is
not recommended to have turned on
see http://www.allenbrowne.com

Pieter

 

[Brendan Reynolds]

What controls are you using on the form for those fields - text boxes or
combo boxes? If text boxes, that is the expected behaviour. If combo boxes,
make sure that the Column Count property of the combo box is set to 2 and
that the width of the first column is set to 0 (zero).

You might want to check out the following URL for some of the drawbacks of
using lookup fields ...

http://www.mvps.org/access/lookupfields.htm