ms access - Call method from another form -
i have navigation form 2 subforms looks this:

when button in subform clicked, call method subform b. method defined this:
public sub mymethod() debug.print "mymethod called" end sub i tried using forms!subformb.mymethod error database cannot find referenced form 'subformb'. referring this page, tried forms!navigationform!subformb.mymethod database cannot find referenced form 'navigationform'. know how properly?
thank you.
function , sub procedures defined in class module of form considered private form. if want sub can called several different forms move sub "regular" vba module (i.e., 1 created when choose insert > module menu bar in vba editor) , sure declare public.
Comments
Post a Comment