I did catch the LOAN_NUMBER error. However, that didn't fix anything. Let's try this. Here is the query that I use to populate the form.
SELECT tblLoanData.LOAN_NUM, tblLoanData.BOR_LAST1, tblLoanData.PROP_STATE, tblLoanData.LOAN_PROGRAM, tblLoanData.DT_FUNDED, tblLoanData.TITLE_INFO, tblLoanData.INVESTOR_INFO, tblFDR.FDocsID, tblFDR.LOAN_NUM, tblFDR.AuditDate, tblFDR.AuditorID, tblFDR.AuditorName
FROM tblLoanDataLEFT JOIN tblFDR ON tblLoanData.LOAN_NUM = tblFDR.LOAN_NUM
WHERE (((tblLoanData.DT_FUNDED)>#1/1/2019#));
The openform command:
DoCmd.OpenForm "frmFDRInput", acNormal, , "tblLoanData.LOAN_NUM = '" & Me.cboSearchLoans.Column(0) & "'"
I have stepped through all the lines from clicking the button, to this statement executing.
The value of "tblLoanData.LOAN_NUM = '" & Me.cboSearchLoans.Column(0) & "'" is "tblLoanData.LOAN_NUM = '123456'"
I put the loan number in the query in Access and found a record. So, I'm lost.