Stupid sodding code.... specifically filters on toggle buttons...please help !!!!!!

B

benj.lewis1

Trying depserately to resolve this one issue. I am tring to filter
subform [Process list] based on value "DP" in the [process] field..
Everytime I run it, I get prompted for a mesage box asking for the
value of DP !!!

I can't sleep, getting ratty and any help would be appreciated.

Me.process_list.Form.Filter = "process=" "dp"
Me.process_list.Form.FilterOn = True

Am I being bone?

SIS
 
J

John W. Vinson

Trying depserately to resolve this one issue. I am tring to filter
subform [Process list] based on value "DP" in the [process] field..
Everytime I run it, I get prompted for a mesage box asking for the
value of DP !!!

I can't sleep, getting ratty and any help would be appreciated.

Me.process_list.Form.Filter = "process=" "dp"
Me.process_list.Form.FilterOn = True

Am I being bone?
Click to expand...

Try

Me.process_list.Form.Filter = "process='dp'"

That's with singlequotes before and after dp.

John W. Vinson [MVP]
 
Top