Filter not Working

[rry2k]

I'm trying to set a filter on a form at runtime. I tried using Me.Filter = "EmployeeID = 4" but it displays all records. After I get this test to work I'll need to set the filter to a value selected in a dropdown.

Thanks for the help..Russ

 

[jebry]

Hi Russ!

Did you set Me.FilterOn = True?

hth Jeff Bridgham
bridgham@purdue.edu

 

[rry2k]

Not at first but I have it now.

Thanks..Russ

 

[rry2k]

My filter seems close but I still have a bug.
When I use: Me.Filter = "[time card hours].EmployeeID = [Time Card Hours1].EmployeeID" It prompts me with a parm box asking for the [Time Card Hours1].EmployeeID. This is filled in as a result of a combobox selection that it's bound to.

I'm lost ..Thanks for the help..Russ

 

[jebry]

Hi Russ!

Try this:

Me.Filter = "[time card hours].EmployeeID = '" & [Time Card Hours1].EmployeeID & "'"

hth Jeff Bridgham
bridgham@purdue.edu

 

[rry2k]

Jeff,

I got an error 2465 that said "Can't find the field '|' refered to in your expression.