Hi -

I have created a combo box on a form which is designed for the user to select a contacts name.

I created a view, based on my contacts table that only pulls the ncontact_id, ccontactfirst, ccontactlast fields.

I named the view, "contact_alphaname"


So, when I go into the form designer I select the combo box with the wizard enabled and the builder pops up.

I select all three fields and choose to store the result in the current form (officeassignment_ncontactid).

In the properties I set the bound property to 3
Bound to = True


OK, here is my problem, when I run the form and go to the combo box, the names of the contacts are there, but when I select the name I want, it only puts the first or last name ( depending upon which one I selected first back in the builder) into the text box.

I want to have both first and last names go into the box, but the builder doesn't give me that choice.

How can I get this to work the way I want? I believe I need to build an expression in the row source property for the combo box, but I do not now the proper syntax to accomplish this goal.

I would sure appreciate any help with this.

TIA

Jason