Filter based on Combo-box column 2


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
 
Ad

Advertisements

G

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)
 
Ad

Advertisements

G

Guest

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
 

Top