Combo RowSource

[Bill]

I have a combo box whose underlying
query contains [FirstName] and [LastName]
as separate table fields. I want to populate the
RowSource with a formatted name:
"lastname, firstname". I tried to use a function as the
RowSource: =CompName([Lastname],[FirstName])
but that didn't work. Can I somehow code the
underlying query to define a field wherein the
first and last names are already formatted as I've
described above? If so, what's the syntax of the
expression?

Thanks,
Bill

 

[Graham Mandeno]

Hi Bill

You need a query with a calculated field. This goes into the field cell in
the query grid where you would normally select a field name.

FullName: [LastName] & ", " & [FirstName]

 

[Bill]

Thanks Graham, that's the syntax that I didn't
stumble onto.
Bill

Hi Bill

You need a query with a calculated field. This goes into the field cell
in the query grid where you would normally select a field name.

FullName: [LastName] & ", " & [FirstName]

--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

I have a combo box whose underlying
query contains [FirstName] and [LastName]
as separate table fields. I want to populate the
RowSource with a formatted name:
"lastname, firstname". I tried to use a function as the
RowSource: =CompName([Lastname],[FirstName])
but that didn't work. Can I somehow code the
underlying query to define a field wherein the
first and last names are already formatted as I've
described above? If so, what's the syntax of the
expression?

Thanks,
Bill