How can I copy a record from one form as new one on another?

[Kirt]

I have one simple form that contains several multiple
addresses for some clients. I would like to double-click
on a selected client's address and my Orders form open up
with a copy of that specific client's address.

I really appreciate anybody's help on this

Thank You,
Kirt

 

[John Vinson]

I have one simple form that contains several multiple
addresses for some clients.

Correction: You have one TABLE that contains several addresses. Forms
don't contain any data. They are *windows* which *display* data which
exists in Tables, and only in tables.

I would like to double-click
on a selected client's address and my Orders form open up
with a copy of that specific client's address.

If you're talking about copying an address from one table to a second
table, and storing it redundantly, the answer is probably - DON'T. The
whole POINT of a relational database is that you can store information
once, and thereafter just look it up using Queries.

What is the underlying table structure? What are you trying to
accomplish with this copy operation?

 

[Kirt]

Basically, when a client needs to have work done at one
of their many addresses I thought it would be great to
double-click on an address and have that address added to
an order (form).

Please let me know what you think if I'm even going in an
easy direction?

Thank you John

-----Original Message-----

 

[John Vinson]

Basically, when a client needs to have work done at one
of their many addresses I thought it would be great to
double-click on an address and have that address added to
an order (form).

Please let me know what you think if I'm even going in an
easy direction?

No. You're not. <g>

Storing the address redundantly is NOT A GOOD IDEA.

What you should do instead is have (as I expect you already do) a
Primary Key in the Address table; you would use a combo box or some
other tool to insert the value of that primary key into the Work
table. This table would have fields for the ClientID (for whom are you
doing the work), the AddressID (where), and additional fields
describing the work to be done.