combine first and last name in combo box

[angel 82]

i want to combine first and last name in combo box . do I make a new combo box from the wizard or do i use the last name box? Then i want it to be scronized to the record i selec
thank you

 

[Douglas J. Steele]

I'd create a query that concatenates the two as a computed field, and base
your combobox on that query.

Something like

SELECT DISTINCT [FirstNm] & " " & [LastNm] AS FullNm, FirstNm, LastNm FROM
MyTable ORDER BY LastNm, FirstNm

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

i want to combine first and last name in combo box . do I make a new combo

box from the wizard or do i use the last name box? Then i want it to be
scronized to the record i select