Filtering on text field

  • Thread starter Thread starter szag via AccessMonster.com
  • Start date Start date
S

szag via AccessMonster.com

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
 
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] & "'"
 
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,
you enclose the value in #.

Me.Filter = "[ITResource_LName]='" & Me![tbITResource_LName] & "'"
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:
Click to expand...
[quoted text clipped - 11 lines]
Zag
Click to expand...
Click to expand...
 
Back
Top