My query has suddenly stopped working. I didn't make any changes but now I get a Dlookup syntax error

Question

I'm using Dlookup to reference another table; however, now I get a syntax error with COMMAND_ID = saying that I'm missing an operator.

I also get an error

This expression is typed incorrectly, or it is too complex to be evaluated

My code:

((DLookUp("COMMAND","COMMANDS","COMMAND_ID = " & [TAD_FROM])) Like "*" & [Forms]![MEMBER]![SEARCH_TAD_FROM] & "*"))
ORDER BY MEMBERS.RANK DESC;

I have looked at backed up earlier versions of the query and nothing has been changed from when it worked before. I have also bounced the syntax off of Microsoft's documentation.