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