I am trying to setup a subform that is displayed only when a stored procedure yields results. I would then like for the subform to not be displayed if the stored procedure yields no results. What If / Then expression can I use? I keep getting "no value" errors for all of the expressions I try. Thanks for any help.
I think I may have asked my question wrong. I need help with the expression. I have the form setup and ready to go. It gets its recordsource from a stored procedure.
Currently, it is being displayed at all times. I would rather have it setup to be displayed only when a criteria is met in the underlying form. As an example, I have a subform that has notes and their respective type of note. Also, not all records have notes. What I would like to see happen, is if the record has a note with type 1, then my subform will popup. If the record does not have a note with type 1 OR does not have a note at all, then the subform does not popup.