Jon  
Just let Access show you.  Create a query in the query designer and get it working.  Then switch the query window over to SQL view where you can then copy and paste the SQL to compare Access' SQL and yours.
Very valuable method for learning the SQL Language.

Why do you need the SQL string to open your form? The way you have it written the entire Select statement is going into the Where Condition of the OpenForm Method. Unless there is a particular reason for the SQL I would use the middle option.

Also, you don't need the quotes around the date.
DoCmd.OpenForm "AfterDavidInvoicedatefollowup", , , "DateInvSentAdj = #2/27/2022#"

got a follow up question, I went with the  code

DoCmd.OpenForm "AfterDavidInvoicedatefollowup", , , _
"DateInvSentAdj = #" & Nz(Forms!UpdateClaimAfterDavidisFinished!DateUpdate, "") & "#"

This is a continuous form, how could I make it sort on last name when the form opens. Then after I have the form open is it possible, with VBA to sort on any column, just like you could if you open the query?  I bet there is a video and I am not using the right search criteria.

Access Search Seminar

just had remember seeing in a video somewhere where I could do this:
Private Sub LastNameSort_Click()
Dim SQL As String
SQL = "SELECT * From AfterDavidInvoicedatefollowup ORDER BY ClmLast DESC;"
DoCmd.OpenForm "AfterDavidInvoicedatefollowup", , , SQL
'rename LastNameSort label to Last Z-A
'click again rename LastNameSort label to  Last A-Z
End Sub

I am searching though videos, any hints please

thanx Alex