To make it easier on the user in making a selection from a combo box, I am trying to display information from multiple fields in the combo box. I have successfully done this before with fields from the SAME table, but I was hoping I could also do it with fields from RELATED tables.

Below, is the code I entered in the RowSource for the Combo box:

vac.nmbr,prlink.fname,prlink.lname

I have SET a RELATION between the tables with regard to nmbr (employee number). Obviously, along with employee number, I'm trying display first & last name from the related table.

Alas, I get a "'field' phrase is not found" error when trying to run the form.

Any help would be greatly appreciated. Thanks.