Combo Boxes

[LTPJ]

How do I join fields in a table to display in an imput field of a form.  ie: employess name from table with 3 fields, title,  fname, lname.

 

[Guest_imported]

One thing you could do, to keep it simple, is just put a:<br><br>SELECT DISTINCTROW

.[Field1],

.[Field2] FROM<br>

<br><br>Put that into the 'Row Source' properties of the combo box and it will create two rows.&nbsp;&nbsp;The first of which will contain data from 'Field1', and the second containing data from 'Field2'.&nbsp;&nbsp;You will have to play around with the column count, and the column and list widths to make this look nice though.&nbsp;&nbsp;I'm sure it's not optimal, but like I said it's fairly simple.&nbsp;&nbsp;Good luck! =D