call function that written in form from module

kirubagari

Dear expert,

i had written the code in my form

Expand|Select|Wrap|Line Numbers

 
Public Function HoldType(ByRef sType As String) As String
 
If bOkClicked Then

 sType = "Rehold "

End If
 
If bOk1Clicked Then

sType = "MultipleHold"

End If
 
End Function

i want to call it in my module as below

Expand|Select|Wrap|Line Numbers

 Public Function HoldReleaseLot(sActionType As String) As String
 
Call HoldType ()

i unable to perform this..What is the method calling function that written in form in module

Kindly help

MikeTheBike

Hi

You do not indicate what application you are running the code in, but, on the basis that the form is open, then, if its Excel or Access (and I suspect .NET or any other language?) then you need to refer to the form Object/Class by name something like this

In Excel

Expand|Select|Wrap|Line Numbers

 Public Function HoldReleaseLot(ByRef sActionType As String) As String

    UserForm1.HoldType sActionType

End Function

In Access like this

Expand|Select|Wrap|Line Numbers

 Public Function HoldReleaseLot(ByRef sActionType As String) As String

    Form_YourFormName.HoldType sActionType

End Function

OR like this

Expand|Select|Wrap|Line Numbers

 Public Function HoldReleaseLot(ByRef sActionType As String) As String

    Forms("YourFormName").HoldType sActionType

End Function

HTH

Note sure what the ultimate doing, but as it stands both HoldType and HoldReleaseLot could be a Subs rather that a Functions!?

MTB

call function that written in form from module

Post your reply

Similar topics