procedure not defined

S

seeker

from a button on one form the following is executed:

DoCmd.OpenForm "frmStratificationFormSecondCheck", acNormal
Forms!frmstratificationformsecondcheck!cmbName.Value =
Forms!frmHealAssessmentSecondCheck!cmbMemberNumber.Value
Call cmbName_AfterUpdate

an error "procedure is not defined" is thrown. How do you call an
afterupdate procedure from a button. I have looked at a few other threads
and the above seems to be correct.
 
J

John Spencer

In order to call a procedure in another form,
-- the form must be open
-- the procedure must be PUBLIC not Private
-- and I believe you need to call the procedure with something like the
following syntax. My syntax on this could be wrong as I never do this.

Call Forms!frmStratificationFormSecondCheck.cmbName_AfterUpdate

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
R

ruralguy via AccessMonster.com

The procedure needs to be Public to reference it from another form.
 
S

seeker

when i make cmbname_afterupdate public a systme count error occurs and all my
forms disappear.
 
Top