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
thank you
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
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)
scronized to the record i select
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)
box from the wizard or do i use the last name box? Then i want it to beangel 82 said:i want to combine first and last name in combo box . do I make a new combo
scronized to the record i select