For starters make sure that both tables are in the forms record source. Now in the row source type of the combo box pick FIELD LIST. Then pick the field from the table that you want the combo box to list. In the control source field put in the name of the field that you want the data to be stored in. Hope this helps. Feel free to email me and let me know how you made out. [email protected]