Form Using Data Entry Both Ways

[95DSM]

Ok, so I have 2 forms. One is an "Add" form and a "Update" form. The Add form has multiple combo-boxes and a few text entries fields. For its purpose, the form has Data Entry turned on. The Add form works perfectly. My Update from on the other hand has a problem. I have Data entry turned off. When the form opens it shows the first item in my inventory and allows for updates with the combo boxes. But if I change a text box it directly changes that field in the main table. I would like it to create a new entry to the table and save for that particular entry. Is there a way to accomplish this? If it requires code can you please provide me a small example?

Any suggestions would be greatly appreciated.

[rpeare]

What you're describing is not an update, an update is when you want to change the data on an existing record, you're talking about generating a new record for every change you make, which should be done on a secondary table that tracks your changes.

For instance if you have 10000 items and you want to track how many items are taken by date you would not do that on the main table you would create a secondary table that had the itemID, the amount taken and the date it was taken and sum those for comparison to your total rather than modifying your total.

[95DSM]

See thats what I dont want to do. I dont want to generate an entirely new Entry just because I changed one field. I would like to keep the same entry and modify the field without changing that same field in my other entires.

For instance.... I have a hardware DB. It contains model number, mfg, serial #, etc.

If I pull up item 245, which is manufactued by Dell, and I want to change the POC for this particualr item, I want to be able to overwirte John Smith and type Mike Brown. But I dont want it to do this for all records that have John Smith. Only this particular one.

[rpeare]

Do you have a primary key for each computer? A value that is not duplicated and can not be duplicated for any other computer within your system? If so you can perform an update query based on that primary key and it will only affect the computer that has that primary key.

[June7]

What is the table structure? Do you have a table of contacts? Does the hardware table have a field that is linked to the contacts table by saving the contactID? What is the relationship of these tables? Is this form's RecordSource a query joining these two tables? Sounds like you are changing the name in contacts record.