Display 2 fields in combo box

  • Thread starter Thread starter Julie
  • Start date Start date
J

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!
 
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
 
Back
Top