>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
Combo always populates its text portion with the first column item. Here you have opportunity to make a trick: add first invisible column to the combo (Combo.ColumnWidth=0) and populate it with whatever you want to see in the text portion, e.g. in your case Alltrim(lastname)+", "+Alltrim(firstname). Do not forget to shift BoundColumn by 1.
BTW, these tricks can be done even more smoothly using grid.
Edward Pikman
Independent Consultant