Saving data

M

Mary

I have a purchasing log that I updated. It seemed to be working fine, but
now when you enter data for the part number and save it it changes all the
part numbers from previous records to the new part number. Any ideas of how
to fix this?
 
J

John Vinson

I have a purchasing log that I updated. It seemed to be working fine, but
now when you enter data for the part number and save it it changes all the
part numbers from previous records to the new part number. Any ideas of how
to fix this?
Click to expand...

It sounds like you have a continuous Form, and that the Part Number
control is "unbound" - not connected to any table field. Data must be
stored in a Table!

What's the structure of your table? and of your form? Is the form
bound to a table, or are you trying to store data in a form (which
WON'T work!)?

John W. Vinson[MVP]
 
N

NetworkTrade

in addition to JV's input - possibly another this is happening could be due
to the Cascade feature of Referential Integrity....just a potential guess not
really knowing the details of your db.... but it wouldn't have 'just
started'...it would have always done this....
 
Top