Filter based on Combo-box column 2

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

Guest

I have a combo-box on a form with 3 columns, ID (primary key), surname,
forename and have column widths of 0;2cm;2cm... hiding the primary key for
easy reference by the user.

I want to be able to filter this field by Surname (text that is found in
column 2) . I cant filter directly and ive tried creating another control,
referring it to column 2 then filtering the additional control, but that
doesnt work either.

Anyone have any ideas ??

Thanks
 
The column numbers start from 0, so if you want to refer to the second
column, surname, you need to use that

Me.[ComboName].Column(1)
 
Yeah that i've got, but the filter function in the context menu is
disabled... and thats what i'd like.

Ofer said:
The column numbers start from 0, so if you want to refer to the second
column, surname, you need to use that

Me.[ComboName].Column(1)
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck



Widemonk said:
I have a combo-box on a form with 3 columns, ID (primary key), surname,
forename and have column widths of 0;2cm;2cm... hiding the primary key for
easy reference by the user.

I want to be able to filter this field by Surname (text that is found in
column 2) . I cant filter directly and ive tried creating another control,
referring it to column 2 then filtering the additional control, but that
doesnt work either.

Anyone have any ideas ??

Thanks
Click to expand...
Click to expand...
 
Back
Top