Thanks for the reply. The initial combo box and the query both act as expected. The appropriate name and the generic "Test" appear in their fields in the table when I select a name in the combo box, and when I run the query they both also appear. And, no, none of my tables are lookup tables...