Filter based on Combo-box column 2

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Widemonk - 26 Oct 2005 12:02 GMT

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

Reply to this Message

Ofer - 26 Oct 2005 13:00 GMT

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)

Signature

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
[quoted text clipped - 8 lines]
>
> Thanks

Reply to this Message

Widemonk - 26 Oct 2005 14:19 GMT

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
[quoted text clipped - 13 lines]
> >
> > Thanks

Reply to this Message