Filter based on Combo-box column 2

[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

 

[Guest]

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)

 

[Guest]

Yeah that i've got, but the filter function in the context menu is
disabled... and thats what i'd like.

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

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