combine two text boxes into one combo box

[JackBurton07]

Hi I want to combine firstname.text and surname.text so that the fullname will be displayed in a combo box that is used for searching

how can i combine these two text box values so that the full name is in the combo

e.g

First Name : Bob
Surname: Smith

Quick Searchcombo box) Bob Smith

 

[saintedmunds]

Hi

How are you getting your data?

If its from a database then use something like this

Select Forename + " " + Surname as Name From Mytable

Cheers

 

[JackBurton07]

the data is coming from access db

myRecordSet.Open("Select* from client where firstname and surname ='" & cboclient.Text & "'", myDb)

is this correct?

thanks

 

[saintedmunds]

Hi

Im not sure your select is going to work as you are looking for a firstname and a surname = to cboclient.Text

Are you trying to populate a combo box from a database and combining the firstname and surname?

If so this should work

Dim myString as string

myString = "Select firstname & " " & Surname as Fullname from client", myDb)

myRecordSet.Open(myString, myDb)


Try That