simple question needed to help

[sup919]

hi there
got a simple question to ask
if i have a function in formA how do i run function in formA from FormB i have try
Forms![formA]!funvt(an)
and it didn't work so where did i go wrong
many thanks

 

[RoyVidar]

Three things:
- Forms![formA].funvt(an) dot (.) in stead of bang (!)
- the function needs to be declared as public, not private
- formA needs to be open

You'd usually also assign it to a variable, form control...

[tt]myvar = Forms![formA].funvt(an)[/tt]

Roy-Vidar

 

[sup919]

thanks dude it work