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.)
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
"John Muff" <JohnMuff[ at ]discussions.microsoft.com> wrote in message
news:8E19841C-4406-4B02-B10A-D3DEAC5DF265[ at ]microsoft.com...
[Quoted Text] >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
>
|