Hi Guys
i have a strange problem to scratch my head with...i have a multiple column combo box...which lists the first name and last name .....and a subform which contains the information to be searched based on the selection made in the combo box......The combo box is laid out on the form.....The combination of the first and last name is a primary key....and iam populating the values from the Table(containing Last and First name)..this table is linked to the table shown on the subform....And the table on the subform also contains First and Last name fields....I need to search only by the last name..if more than one last name appears i need to search by the combination of last and first...well Please solve this and help me..