I have a button that refreshes my form that contains a subform. This sub form might be empty depending on the conditions of the main form. I would like a message box to appear when the form is refreshed and the subform does not contain data, what are my options?

Thanks,

MTmace

[This message has been edited by MTmace (edited 04-25-2002).]

When yo click the button, use VBA to check the record count, i.e., rs.recordcourt or alternativlely if rs.eof and rs.bof then no records.