Save data in table

[SelfLearner]

Here is what I have in my Form. From Table 1: Vender Name, Number, contract, amount, quantity,and order number. Table 2: Doc #, Date. Multiple Doc #'s and dates will be saved under one vendor name (hence the two tables). What I need is a MACRO where once I save the Doc #and Date to a record, I need to be able to go back to that record and enter a new Doc # without saving over the one I originally did.

[orange]

Can you tell us in plain English---no Access and no jargon --WHAT you are trying to do?
If you met someone in the McDonalds line up , what would you tell them your database is about-- they don't know you; they don't know database or Access?

You may wish to review some free data models at http://www.databaseanswers.org/data_models/index.htm

Good luck with your project

[SelfLearner]

I need to know how to use a Form that has information recorded to 2 tables. Some of the information in the Form will stay the same except for 4 records in which I need to update without just writing over what I previously typed. Example. I have a name selected from a drop down list. It brings up all the information I typed in the form. In the document number text box I need to add another document number without deleting the one already there. Is there a way to do that? I can't explain it any easier.

[orange]

So,in plain English, you have some people names. For 4 of those people names, you need to create new documents.

Is that it?

[SelfLearner]

The names will stay the same. The names will have multiple document #'s tied to each name. Example: Vender Name: Home Depot Pr #: 12345, etc. All of that info will stay the same on down the form is Doc #, Doc Date, etc. this needs to be changed (without being written over) and updated while the vender name, PR #, etc stay the same

[orange]

I don't think that is your issue. I think you have either not identified, or not told us about the underlying application. I see PR# and Doc# and DocDate.

Is this dealing with Purchases/Orders and /or Invoices etc?

Another point for consideration:

Use a naming convention that uses only [A-Z][a-z][0-90 or [_]}(underscore). This will save you many syntax errors and frustration. No embedded spaces, no special characters #@&}{%!+)( etc.

I think you should read this tutorial to get an overview of database design, table structure, Normalization and relationships.
http://www.rogersaccesslibrary.com/T...lationship.zip

Get your tables and relationships designed and tested before getting too deeply involved in Access, forms, queries, macros, vba etc.