Recent content by TxRedRaider

The actual query and the sql are accurate. It changes the query based on the input, however the issue is with the docmd.openreport command. thats where the debugger stops. The sql works for the query, however when i try to open the report based on the query, thats when the issue arises of an...

I tried both suggestions with no luck. All of the variable and field names are spelled correctly and the "space" in the syntax made no difference. I think im going to throw my laptop out the window to see if that helps....

This is driving me insane. I have a batch of code to open up a report. I want that report to be based on a query. ive done this multiple other times in this particular database, but for some reason when i run this particular batch of code it pops up with a box that asking you to put in a value...