Row Source Changes in All Records When Changed in Any One Record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Problem: When a user adds or changes a value in a form field (and several
others), it changes the value of this field in ALL of the other records to
this exact same value. For example, if I were to change (or add) a value of
"Letter" in one record, ALL of the other records will now change to "Letter."
This began happening out of the blue, as far as I can tell.

Version: Microsoft Access 2000 9.0.3821 SR-1

Pertinent Info: Row Source Type is Value List. Row Source code, using the
example above, is "Letter";"Email";"Phone". Control Source is tied to the
main table.

Thank you for any assistance you can provide.
 
cmberger929 said:
Problem: When a user adds or changes a value in a form field (and
several others), it changes the value of this field in ALL of the
other records to this exact same value. For example, if I were to
change (or add) a value of "Letter" in one record, ALL of the other
records will now change to "Letter." This began happening out of the
blue, as far as I can tell.

Version: Microsoft Access 2000 9.0.3821 SR-1

Pertinent Info: Row Source Type is Value List. Row Source code,
using the example above, is "Letter";"Email";"Phone". Control Source
is tied to the main table.

Thank you for any assistance you can provide.
Click to expand...

Sounds like the control is not bound to a field in the form's RecordSet.
Double check the ControlSource property.
 
Back
Top