Problem editing data in form

[nwalk81]

I'm having a problem editing data from my forms. If I change one field of one record on the form, each record changes. This change does not effect the tables just the form and query (were appropriate).
Any suggestions?

My goal would be to have the changes, indivdual and reflected throughout database. Meaning I want the tables to reflect the changes made. I believe it is an update problem, but I'm not sure.

Thank you in advance for all your help.

 

[jdegeorge]

If you have form based on either a query or a table and the form is set to allow edits, then they should be saved in the table or underlying table in the query. Are you sure your fields aren't UNBOUND?

Jim DeGeorge

 

[nwalk81]

The fields are bound. They come from sub forms, and each time I make a change to one field of one record, the change is reflected throughout most of the records with small exceptions. I do not understand why this is occurring.

ex. Say you had a color field and you changed the entry red to blue for one record. Each record that had red is now changed to blue.

Can you help?