DoCmd.OpenForm with multiple macros

[Ekhart]

I have a couple of different macros that combine to make a filter I want run with the DoCmd option. I can get either to run individually but cannot seem to get the code to work to combined them.

DoCmd.OpenForm "frmActionNeeded", acFormDS, , testingmacro

works, but if I try

DoCmd.OpenForm "frmActionNeeded", acFormDS, , testingmacro & strRange

it does not.

[ranman256]

the 3rd argument is the WHERE clause, it must look like sql
DoCmd.OpenForm "frmActionNeeded", , , "[field] between #1/1/17# and #2/1/17#"

[pbaldy]

Presuming those return valid strings, try

DoCmd.OpenForm "frmActionNeeded", acFormDS, , testingmacro & " AND " & strRange

If that doesn't work, it would help to know what the variables contain.