Concatenate combo box results

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top