combine first and last name in combo box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)



angel 82 said:
i want to combine first and last name in combo box . do I make a new combo
Click to expand...
box from the wizard or do i use the last name box? Then i want it to be
scronized to the record i select
 
Back
Top