Can it be done ?

[John Muff]

I am creating a user friendly form, 1 pager, that track everything I need. I
want to be able to select a name from a dropdown menu, which then paste the
selected record (All fields from the query selected) to my main table (&
Form).

I want to select someone record from a list and link this individual and his
informations to the main table; maybe with a command button only visible when
the dropdown in not equal to the currently selected one. Sould I use a
subform ?

When the information is entered in the associated field of the master table,
I
am able to put them in a single line, in a single field on my form. (I dont
know how to seperate the words by spaces automatically). I want to see the
"Word, Tools, Enveloppe & Label" menu box appear when I click on a command in
Access, I know I'm asking alot, but it must be possible...

Hoping you understand what I mean.

John Muff

 

[John Muff]

Hi, Is there anyone who could help me out with this one ?

John

 

[John Nurick]

It's not easy. You know your data structure and we don't; and without it
I for one can't follow your description of what you want to do. At one
point it seems to be "paste the selected record" to your main table, at
another it's "link this individual and his informations" (what
informations?) to the main table.

Two things seem clear, though. (1) If you actually need to copy all the
fields from a record in one table into a record in another table,
there's almost certainly something wrong with the design of your
database; and (2) you should almost certainly use a subform.