Lookup field display 1

[BabyPowder2u]

I used a wizard to "find a record on my form based on the value I selected in my combo box"

In my cbolookup I am showing 4 fields. When a field is selected, however, only the the value of the first field is displayed in the cbolookup field.

Is there a way for me to show the result of all 4 fields concatenated together. This has meaning. Showing only the first field has no meaning because this field contains duplicates.

 

[Remou]

Hi
Is this to do with the Column Count and Column Width properties of your combobox?

 

[BabyPowder2u]

Hello Remou,
Well, the answer is yes & no.

What I ended up doing was in the select statement, concatenate the 4 fields "AS fieldname" then changing column count to 2 (first field is key field, 2nd field is the concatenated field which is displayed)

I had looked before to see how I did something similar elsewhere, but couldn't find it then... I just did.

Thanks for the help