How do I stop the chosen lookup value from being propogated through the rest
of my database?
I doubt that it is. Open the table in datasheet view and check value in the
field of those records.
You probably did not bind the form object to the table. You did not say
what kind of object it is - combo, listbox, textbox.

--
Build a little, test a little.


"gravesk" wrote:

Hi -
I am using Access 2003, and am not very familiar with Access or its
terminology. I am not at all familiar with VB.

I created a form from a query, and everything is generally working fine.

One of the fields on the form is based on a lookup table for location. I
have assigned a default value of 1 (which translates to NOT CHOSEN), and
that's how everything shows up when I go into the form. I assigned the
default both in the originating table and in the box on the form itself.

However, when I change the first record to a different value (say, 2 which
translates to QUEENS), then all of the other records now show up as QUEENS
when I page through them.

How do I stop the chosen lookup value from being propogated through the rest
of my database?

Many thanks,
Kristin Graves