Select Single Record to Transfer to another Query/table

[Ray]

Hi,

I'm trying to create a macro that will allow me to search for a record by a
specific field (filed name: Contract Number) select fields from an existing
record in that existing table or query and transfer that data to another
existing query or table to be worked by another user.

So i want to be able to

-Search for contact number 123 (and contract number will change each time)
-Have certain fields from contract number 123 export into another existing
table or query

Can this be done? Please help!

 

[LilMorePlease]

Hi,

I'm trying to create a macro that will allow me to search for a record by a
specific field (filed name: Contract Number) select fields from an existing
record in that existing table or query and transfer that data to another
existing query or table to be worked by another user.

So i want to be able to

-Search for contact number 123 (and contract number will change each time)
-Have certain fields from contract number 123 export into another existing
table or query

Can this be done? Please help!

It sounds like this can be accomplished. I am wondering if the table or
query you'd like to have the data added to already has a contract number
field in it. If it does, you could approach this with an Insert Into sql
statement. If it does not, you would likely use an Addnew method.

I will help you with if it you'd like...

AA