I am receiving: Run-time error '2427' You have entered an expression that has no value.
I have a macro set up so that someone can enter text into a textbox on a form and click a search button. The macro then opens another form with the resulting recordset from a hidden query.
The problem is, if there are no matches (query returns nothing), then the second form appears blank, nothing.
I thought if I checked the value of the result field for Null, at the OnOpen event of the second form, then that would tell me if the query returned nothing. However, IsNull returns False. But if i try to debug.print the field, I get the above error.
How does this field have no value yet is not null?