Forms

[Pat]

I have a form that has 14 memo fields. When you enter the
form the 14 fields are not visible. A subform has 14
command buttons which turns on a particular memo field
that is needed.
My problem is: When i click one button and I choose to
turn on another memo field I do not know how to close one
down the one that is on and expose the other.
When i click on another button it will visiablly overlay
the other.

Can anyone please help?

Pat

 

[j]

One way would be to use Tabs. Make each memo field on a
different tab.

Is each memo field a seperate form or are you
hiding/unhiding the memo field controls?

Jim

 

[CDS]

Have you tried the event specific VB to exit? This is
found in the properties box of each memo field in the
form. You can use "after update", "on click" etc. Click
on event procedure and use the following: DoCmd Close