Search results

I found the following to be an issue WHERE type= '" & pgroup & "' Access 2007 was throwing "Run-time error '3075' because it was having an issue with the single quotes so I change it to this: WHERE type = """ & pgroup & """ Also remember that the above "type" is the name of the column from...

Nevermind... =[Forms]![PickDateRange]![txtDateFrom]

Okay, one last question. How do I take the user entered dates from the filter screen and put them on the report? Thanks!

Awesome, works perfect now! Thank you VERY much for all of your help!

Pick is set to: InitActDate myCriteria is set to: myCrieria is set to: Between #1/1/01# And #1/1/07#

Ok, so in the second message box, myCriteria is set to nothing.. when it should be set to one of the list selections.

How do I test that?

Hi, I am having a little difficulty with my report filter. How to I make the filter form so that the user can select from different date fields for the start date and end date to pull from?? For example have the option so that the user can sort start to end date from IssueDate, InitActDave...