[AccessD] Access 2007: Lookup Field Shows Correct Value Selected, But Not Displayed

Opening a data view of an action query may not display anything useful,
if that's what you're describing.  Or do you mean that you ran the query
and got zeros instead of 8s?

Charlotte Foust   

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gale Perez
Sent: Sunday, July 15, 2007 7:22 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Access 2007: Lookup Field Shows Correct Value
Selected,But Not Displayed

Hello,

I'm normalizing a db to replace certain fields with lookup fields.  I
used the lookup wizard and am storing an autonumber from the lookup
table.  All updated just fine, except for one.  The old field is a text
field consisting of the numbers 0-7.  I created a query to update the
new field (in the example, 8 is the autonumber PK in the lookup table):

UPDATE mytable SET mytable.newfield = 8
WHERE (((mytable.[oldfield])="7"));

But when I opened the table to verify the new field's data matched that
in the old field, I saw that the new field showed nothing but zeros.
When I clicked in that field of a particular record, my dropdown box
appeared, with
the correct value selected - but it is not being displayed!   What the
heck
is going on?  Has anyone else had this happen?

I tried re-creating both the query and the field, and got the same
results.

Thank you very much for any thoughts!
Gale
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com