Entering new data, instead of editing record

[waldo7474]

Hello,

I am pretty new to this access thing, I took a class a couple of years ago and trying to remember what I learned. I never learned vba, but thanks to this forum am starting to understand it a little. Anyway here is my dilemma:

I have a form that is based on a query. The form asks the user to enter a Part Number. The database searches for this Part Number if it finds it, it returns the part, if not it lets the user enter the part into the database as new. If the part is already there, updating to the record needs to be done. However, I do not want to lose the old information. How can I be sure to not type over information already there.

I have a one to many relationship so that for many part numbers there can be many revisions (the revisions are in a seperate table). When I pull up the part number only the last revision shows, but if I type over it that info is lost. I want to be able to show all relative information to the part, but want to be able to change the revision and store the older values as well. I am sure this is possible, but not sure how to do it.

I hope this makes sense. If more clarification is needed, let me know. Thanks to anyone that can help.

 

[HFloyd]

waldo7474,

Perhaps what might work is if you have your form set up as such:

Box to choose/type Part Number

Subform displaying existing Part Number data (if any) (set to read-only to avoid altering the data)

Subform to add new Part, or create a new "revision" for Existing Part

Let me know if this begins to address your issue.

Heather

http://www.floydinnovations.com