I have a form which is being used to enter criteria of a report.  While this
form is open I would like to have an "Advanced>>" command that would
drop/expand the bottom of the form with additional search options.

My attempt: I inserted a sub form with the additional search options on the
footer of the main form minimized in design view with the following
properties, can grow, can shrink and not visible.  In the main form I set the
properties to can and can shrink.  My expectations were to have the procedure
behind the command set the sub-form visible property to TRUE.  Although the
Sub-Form appears the Footer does not expand therefore it overlaps.  I also
placed it on the bottom of Detail but it just didn’t allow the sub-form to
grow or overlap.

Thank you in advance for your time.