Lookup and copy a record

[bcbuyer]

I have a table of Terms and Conditions with codes "A01" and Description "Blah, Blah, Blah".

When creating a Proposal for our jobs I want to select Terms and Conditions by the code. I have this setup currently to lookup the values. My problem is that I want to be able to edit the Terms and Conditions for each job making them unique.

How do I lookup the the Description using the code and then copy the record into a new table that I can edit?

 

[dhookom]

Please share your significant table and field names and data types. It would also help to understand your forms/controls used to edit this information.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[ProgramError]

Take a look at the dlookup method and use an append query.

Ian Mayor (UK)
Program Error
Always make your words sweet and nice. Because you never know when you may have to eat them.