Search results

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 =...

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...

I edited my post. I figured out what was wrong to get the Enter Parameter... Issue. Now, it's just not populating the form. The form has many tabs with subforms on them. The previous version of this application used an sql statement and re-assignment of the recordsource to get the correct...

Unfortunately, I can't attach the db because of the nature of the data. Not shareable. I have run the recordsource query to see if I could find the loan number. It's in the results. But when I try to open the form with the where statement, I get the enter parameter. I figured this part out...

The field name does have an underscore in it. I did set a breakpoint and the values were correct. No, the loan number does not have an apostrophe in it.

No, it's the Loan Number so it is text.

Ok, I have read through all of these posts and I've tried everything that was suggested and I'm still getting the "Enter Parameter Value". DoCmd.OpenForm "frmChecklistNavigation", , , "LOAN_NUMBER ='" & Me.cboSearchLoans.Column(0) & "'" LOAN_NUMBER is a ShortText The first field in the...