Combo Box Search

[syedadnan]

Regards,

What i am having the problem is when searching record in form iam having this trouble let suppose customer name is Chris Gold and i am not remebering the name of customer and want to search it as gold but the combo box not reaching that name .. any idea how to do that !!!!

 

[bob fitz]

Can you show us what you have as the Row Source property for the combo box.

 

[smig]

combo will search from the beginning of the field, it can't search from the middle.
I guess you put the full name into a single field, so you can search for Chris but not for Gold.

 

[bitzgam]

Name your combo box Sir, let say cboSearch

then go to your query which is the record source of your Form.
In your Query go to the fieldname FirstName or LastName or a concatenation field let say ApplicantName
then on the criteria type this

Like "*" & [Forms]![FormName]![cboSearch] & "*"

hope it helps

 

[syedadnan]

Name your combo box Sir, let say cboSearch

then go to your query which is the record source of your Form.
In your Query go to the fieldname FirstName or LastName or a concatenation field let say ApplicantName
then on the criteria type this

Like "*" & [Forms]![FormName]![cboSearch] & "*"

hope it helps

Thanks A Lot working perfect as per choice