Saving data

[Guest]

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?

 

[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?

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]

 

[Guest]

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....

 

[Guest]

I have retrieved my data. I'm not sure how but it is there. Thanks for the
help.

 

[Guest]

Thanks for the help. The field was unbound. It works fine. Thanks