Hello,
I have a continuous form and one of the text boxes uses a formula as the Control Source. When the Allow Additions property of the form to "No," the error 2185 (can't reference a property...) is triggered anytime someone tries to search for something that is not in the record source. (This is because the unbound control loses its focus even though it has the active control.)
To get around this, I set the Allow Additions to "Yes." The problem now is that in the "new record," the "#Type!" error appears in the field that has the formula. I tried setting a default value and using Nz so there wouldn't be any issues with null values.
Any thoughts?
SearchDefValueErr.accdb.zip