Ok. I get your point. I've done this before. But; 1st; I just realized that the box I am trying to populate is the combobox. I am guessing I need to change this to a text box. 2nd; The form is a subform with a recordsource already linked to the main form. There's no combo boxes for the controls i want to populate from. All controls on the subform are text boxes. The recordsource do not include any of the fields needed. That's why I was trying to do a lookup from another table in the database. I just don't know how to make it work. Sorry for all the confusion. thank you