Running Form Events

  • Thread starter Thread starter Brian
  • Start date Start date
B

Brian

Is there a way/command to run a Form Event from another
form?

Here is my example. I have a main customer form. From
there a user can click on a button (called Associated
Orders) and see all of the orders for this customer. On
this subsequent page, the user can modify or even
completly delete any/all orders. When the user closes
this form to return to the main customer form I want to
run the 'Current()' event (this is where I have all the
code necessary to activate or deactivate a number of
different controls).

I have tried the .Refresh which didn't work and
the .Requery which returned the form to the first record
(not a big deal when there is only one record, however if
there are 300........you can see the problem).

I am really hoping that there is a way to say
"Forms![Customer Main].Current????

Thanks for the help.
 
That is incorrect. The Activate event fires whenever a form becomes the
Active Form.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm



Brian said:
I thought about that but, as I understand it, the Activate
event on the original form does not run when control is
being returned to it from another form.

Correct/Incorrect?
-----Original Message-----
Why not use the Activate event of the Main form instead?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm



Brian said:
Is there a way/command to run a Form Event from another
form?

Here is my example. I have a main customer form. From
there a user can click on a button (called Associated
Orders) and see all of the orders for this customer. On
this subsequent page, the user can modify or even
completly delete any/all orders. When the user closes
this form to return to the main customer form I want to
run the 'Current()' event (this is where I have all the
code necessary to activate or deactivate a number of
different controls).

I have tried the .Refresh which didn't work and
the .Requery which returned the form to the first record
(not a big deal when there is only one record, however if
there are 300........you can see the problem).

I am really hoping that there is a way to say
"Forms![Customer Main].Current????

Thanks for the help.
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top