Filtering on text field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

szag - 21 Dec 2007 14:18 GMT

I am using an on Double Click event to filter based on the current value on
that field. It works when I use it on a number field:

Me.Filter = "[forMthYr]=" & Me![cbMthYr]
Me.FilterOn = True

but when I apply the same code (below) to a text field it does not work - I
get parameter boxes popping up.

Me.Filter = "[ITResource_LName]=" & Me![tbITResource_LName]
Me.FilterOn = True

Any help is appreciated.

Zag

Reply to this Message

Klatuu - 21 Dec 2007 14:36 GMT

It works on a numeric field because there are no delimiters. For text
fields, you enclose the value in single or double quotes. For date fields,
you enclose the value in #.

Me.Filter = "[ITResource_LName]='" & Me![tbITResource_LName] & "'"

Signature

Dave Hargis, Microsoft Access MVP

> I am using an on Double Click event to filter based on the current value on
> that field. It works when I use it on a number field:
[quoted text clipped - 11 lines]
>
> Zag

Reply to this Message

szag - 21 Dec 2007 15:18 GMT

It worked. Thanks a ton!

>It works on a numeric field because there are no delimiters. For text
>fields, you enclose the value in single or double quotes. For date fields,
[quoted text clipped - 7 lines]
>>
>> Zag

Reply to this Message