Help please John Muff 05.07.2006 16:36:02 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