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

  • Thread starter Thread starter benj.lewis1
  • Start date Start date
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
 
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]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filter listbox with toggle button 1
Use VBA Code to Assign Macro Buttons to use Different Queries for Source in a SubForm 0
Filter a subform by a button/toggle on the main form 5
Trying to filter records with combo box 5
Filter data based on Textbox Value 7
VB Code help for Excel 2003 - Please Help 0
Help with autofilter and filtering a specific column 1
Filtering on Linked Tables 1

Back
Top