I have a form opened from another form, filtered by a query with the criteria of a value in a field on the first form. If there is no data brought back by the query, the form opens with just the header label, no other fields.
How can I have a message display that no data was returned instead of just a blank form? I have look at the properties for forms and there isn't an On No Data option for forms. I can't find how to have the query trigger something for no data either.
How can I have a message display that no data was returned instead of just a blank form? I have look at the properties for forms and there isn't an On No Data option for forms. I can't find how to have the query trigger something for no data either.