Well, I want to thank you all for your help and input!! I have figured out that the OpenForm just doesn't work as it should when there is a WHERE statement present. I ran the openForm twice in a row and the data showed up. So, I replaced the second OpenForm with:
frmFDRInput.Filter = "tblLoanData.LOAN_NUM = '" & Me.cboSearchLoans.Column(0) & "'"
frmFDRInput.FilterOn = True
And it worked. I think this may be a bug from the latest update for Microsoft, but at least I got around it.
Thanks again!!!
frmFDRInput.Filter = "tblLoanData.LOAN_NUM = '" & Me.cboSearchLoans.Column(0) & "'"
frmFDRInput.FilterOn = True
And it worked. I think this may be a bug from the latest update for Microsoft, but at least I got around it.
Thanks again!!!