forms...

[vsmith2]

I have been teaching myself how to create databases/ forms using Access, and
I have a question. I just modified a previously constructed form by adding a
few list boxes and combo boxes. For some reason, when I choose a value from
either of the types of boxes, and then move on to the next entry, choose
another entry from the lists and combo boxes, the values change in every
entry of the database, in those particular fields. How can I "lock in" my
box choices per database/ form entry?

 

[John W. Vinson]

I have been teaching myself how to create databases/ forms using Access, and
I have a question. I just modified a previously constructed form by adding a
few list boxes and combo boxes. For some reason, when I choose a value from
either of the types of boxes, and then move on to the next entry, choose
another entry from the lists and combo boxes, the values change in every
entry of the database, in those particular fields. How can I "lock in" my
box choices per database/ form entry?

It appears that your problem is that you're assuming (like many beginners do)
that Forms store data, and are basic to your application. They aren't! Forms
*ARE JUST WINDOWS*; they're tools to manage data, but that data is stored in
Tables, and only in Tables.

If you have a Form Control not bound to any table field, then it will be
displayed whichever table record is currently selected. If you change it while
one record is displayed, it changes for all of them - because the value isn't
in the table at all, you're just displaying just the form control.