Display 2 fields in combo box

[Julie]

Hi;

I have a combo box that lists the full name and company
name on a form. Problem is, it will display only the
company name. The records in my database are varied, some
are companies and some are individuals (this is a client
list), so I need to see both fields displayed on the
form. any ideas? Thanks much!

 

[Larry Linson]

You can create a query that chooses whichever field is not null in a
calculated field, use that as the Row Source, and display the calculated
field -- which will be either Company Name or Full Name. Presumably the
bound column is a separate ID field.

If there are records where both Company and Full Name are filled in, then
you can create the calculated field as the concatenation of them: [CoName] &
" " & [FullName] and display that.

Larry Linson
Microsoft Access MVP