I have a form whos control source is linked to a query. On the form I have an unbound text box that allows a person to type a "search word". This word is supplied to the query and acts as criteria for a field displayed on the form. I find that when a person types a word that does not match criteria, (and the query returns no records), the forms controls disappear in the details section of the form.
How can i prevent the controls from disappearing, or at least capture this event and supply the user with some instruction of what is happening? (IE Something like the reports On No Data event?)