Concatenate combo box results

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a tbl_emp that list the employees by LastName and by FirstName (two
separate fields).

I have a form frm_bundlelog linked to tbl_bundle.

I have the field Assigned_to that is a query based on the selection made in
DocumentType. It is currently returning the LastName from the tbl_emp. I
would like it that when I make the selection of the last name, that the value
that is saved to Assigned_to in tbl_bundle is a concatenated value of the
LastName, First Name.

Is this possible? If so, what sort of code would I need and where do I
enter it?
 
Back
Top