M
Matt
I have a main form, subform, and a subdatasheet form within the subform
linked by a designated field. The user enters criteria and hits the Refresh
CMD button. If a user enters criteria that does not exist in the queries,
the subform will not display any rows, only the column headers. The problem
is when there are Null values in the subform, the subdatasheet form becomes
hidden and will not close properly when the entire form is exited. The
subdatasheet form closes correctly when there are rows displayed on the form.
I tried using code that close the subdatasheet form after exiting, however
no good. Not sure why I cannot close this form when it is hidden. Any
suggestions?
linked by a designated field. The user enters criteria and hits the Refresh
CMD button. If a user enters criteria that does not exist in the queries,
the subform will not display any rows, only the column headers. The problem
is when there are Null values in the subform, the subdatasheet form becomes
hidden and will not close properly when the entire form is exited. The
subdatasheet form closes correctly when there are rows displayed on the form.
I tried using code that close the subdatasheet form after exiting, however
no good. Not sure why I cannot close this form when it is hidden. Any
suggestions?