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

Hi Charlotte,

I ran the query, and when I opened the table (not the query results), it
showed all zeros.  Yet when I clicked in the field, the dropdown box showed
that the correct value was selected (highlighted), it just isn't being
displayed.

Thank you,
Gale


On 7/16/07, Charlotte Foust <cfoust at infostatsystems.com> wrote:
>
> 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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>