Problem in Relationship I guess !?!

J

John Muff

Hi,

I am creating a "as much as possible", 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 master table (& Form). I want to select someone record from
a list and link this individual and his informations to a second table row;
maybe with a command button appearing only when selected record is not = to
the one on file for this record... I believe that the dropdown should not
have a control source, but then it dosent retain information on selected
record. Sould I use a subform, I'm kind of stuck there !

When the information is entered in the bounded field of the master table, I
am able to collate them in a single line, in a single field on my form. (I'll
need to find out how to seperate the words & change the line on a field) I
basically want to be able to press a button from my access form, seeing the
"Word, Tools, Enveloppe & Label" menu box appear, select the label location
and hearing the printer bip for the manual feed request. I know I'm asking
alot, but it must be possible...

Hoping you understand what I mean, Thank you so much for helping me out...
 
Top