Procedure Calling Syntax Needed

SerranoG · October 23rd, 2003, 10:46 AM

What is the syntax or method needed to trigger an AfterUpdate event or an OnClick event of a control that is located in a second open form that is hidden behind the active form? That is, FormB is open and on top (is active, has the focus), but I want to trigger an AfterUpdate event in FormA (hidden behind FormB, doesn't have the focus, not the active form).

FormB is open. Click a button on FormB.
FormA gets the focus.
A combobox is filled in FormA with data from FormB.
The combobox's AfterUpdate event triggers.
FormB closes.

I'm getting a "Procedure not Found" error even if I give FormA the focus first before closing FormB.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

sal · October 23rd, 2003, 10:54 AM

Forms![FormA].SetFocus

Sal

Braxis · October 23rd, 2003, 11:02 AM

Greg

Can't you extract the relevant code from the AfterUpdate event and place it in it's own public Sub/Function?

The you'd just need to place

Code:

Forms![FormA].PublicFunctionName

where ever it's needed

Brian Skelton
Braxis Computer Services Ltd.

sal · October 23rd, 2003, 11:19 AM

I was finger happy earlier,

Try this on the after update of the combo box in FormA

DoCmd.Close acForm, "FormB", acSaveNo

Sal

SerranoG · October 24th, 2003, 07:03 AM

Thanks it works now. Seems that although I had everything in the correct order, including the .SetFocus, the reason Form A's event didn't want to fire off was I didn't express the event as a property. Namely:

Code:

'Old Way, Starting at Form B

   Forms.frmFormA.SetFocus
   Me.cboMyCombobox = Forms.frmFormB.Form.txtMyTextBox
   cboMyCombobox_AfterUpdate
   DoCmd.Close acForm, frmFormB


'New Way, Starting at Form B

   Forms.frmFormA.SetFocus
   Forms.frmFormA.cboMyCombobox = Forms.frmFormB.Form.txtMyTextBox
   Forms.frmFormA.cboMyCombobox_AfterUpdate
   DoCmd.Close acForm, frmFormB

Although the "old" way normally works just fine when I'm starting and ending in the same form, the mere fact that I was starting in another form caused Access to require me to be explicit. I had to express the event as a property and it was confused by the "Me." even though I switched forms, so I had to use the "Forms.frmFormA.".

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division