I am still struggling with my forms and combo box's.  I did make the amateur mistake of using lookup wizard in my table design.  Having lots of problems now that my database is getting larger and trying to make more complex forms. I am currently trying to fix these.  In trying to make some more simple forms and not having large cumbersome forms I have another issue.  I cannot figure out how to bring over a value from one table to the next with a combo box in a form without displaying its primary key.  

Also is there a way in a form to chose from a combo box and it pull forward info such as phone number and Notes.  Scenario-I want to create a form to chose a client and add some additional information to their profile in the table but I would like it if when I chose them from the combo box in the form it would bring forward their phone number and Notes? I am trying not to make the form too large.