On Tue, 20 Apr 2010 08:38:01 -0700, gravesk
wrote:

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.

Check the properties of this combo box ("lookup") on the Form. Almost
certainly its "Control Source" property is blank; this means that the combo
box is not associated with any field in your table, but instead is just
displayed on the form. Since it's associated with the form and not with the
table, you'll get this effect (it makes no difference which record you're on
if the combo box doesn't have any connection with the record).
--

John W. Vinson [MVP]