Access doesnt pick up recordsource

[ItsMe]

I only used qry_A_A_A to get the SQL squared away before I tried to place it in the VBA module. You can use it, maybe, as an illustration of what the VBA string is doing. I can't figure out what you got going on. If you can simplify it, you should.

[JoeyB]

I only used qry_A_A_A to get the SQL squared away before I tried to place it in the VBA module. You can use it, maybe, as an illustration of what the VBA string is doing. I can't figure out what you got going on. If you can simplify it, you should.

I see, to get it hard coded that seems to be the only difference. Life can be simple sometimes haha. Thanks mate!