#ERROR in a textbox

[Pele]

I have created a subform that will display records that
meet a criteria that was entered in a textbox on the Main
form. The subform is based on a query and it is being run
in the Hidden mode. Contents of the some textboxes on this
form are used in other parts of the application.

The problem I am facing is when the query has no records
to show based on the criteria, the subform screen is blank
(as to be expected). What I did then was to create a
textbox (called CHECK) on the mainform to see what value
was in one of the textbox on the subform. The created
textbox (CHECK) on the mainform showed #Error.

The reason why I need to know if the subform has any
record is because, I am running the mainform in the Hidden
Mode and I need to display a message box to the user to
say that no records exist based on the criteria entered.
The #error contents of the textboxes on the subform is
causing error values in other parts of the tool since I am
using Setvalue actions in macros to copy contents of
textboxes on the subform.

The question is, how can I refer to the #Error content of
the textbox if no records are available on this hidden
form.

Pele