VBA code to minimize a form

[Fred's]

Hi Folks,
I have a problem which, I 'm hoping you can helps me with.

I've built an access form. My form is called "DataEntryFrm"
On that access form, I've created a command button called "Send", When
I click on that button, it open another form called "EmailForm".

Now I'm trying to figure it out which vba code I should use to
minimize my form "DataEntryFrm", when clicking on the "Send" button
and in which property event should I put the VBA code? Because, I've
already use the On click event to open the form "EmailForm".

Do you have any idea?

Any help will be very appreciated,

Thanking you all in advance,
Fred's

 

[Steve Schapel]

Fred's,

First of all, the focus of this newsgroup is on macros in Access, which
is not related to VBA code.

Anyway, there is no problem with doing more than one thing on the same
event procedure. So, your code on the Click event of your button can be
like this:

DoCmd.Minimize
DoCmd.OpenForm "EmailForm"

 

[Fred's]

Fred's,

First of all, the focus of this newsgroup is on macros in Access, which
is not related to VBA code.

Anyway, there is no problem with doing more than one thing on the same
event procedure. So, your code on the Click event of your button can be
like this:

DoCmd.Minimize
DoCmd.OpenForm "EmailForm"

--
Steve Schapel, Microsoft Access MVP










- Show quoted text -

Steve,

First of all, I will keep in that newsgroups is focusing on Macros.

Thank you very much for your help, this is vorking prefectly.
Fred's