Help please !

[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

 

[Douglas J. Steele]

You've posted this multiple times, with no response.

I suspect the reason for no responses is because your explanation of what
you're trying to do doesn't make any sense!

If the data is already there (as it would have to be if you say "all fields
from the query selected"), why do you have to store it in another table?

Give more details about what's already in the database (details of tables,
forms, etc.)