Form Name Passed to Module

[bbrendan]

Hi Im just a little stumped.

how can a pass a form name to a module?

for example:

at present that has the form name hard coded like:

frmorders.fOptBegins.Value

But Becuase I want to use the same module on a different form how can I make "frmOrders" a variable of which ever form it was called from

ie:
frm.fOptBegins.Value

thanks

 

[PatrickIRL]

Hi Im just a little stumped.
how can a pass a form name to a module? for example:
at present that has the form name hard coded like:
frmorders.fOptBegins.Value
But Becuase I want to use the same module on a different form how can I make "frmOrders" a variable of which ever form it was called from
ie:
frm.fOptBegins.Value

Hi,

Change your module to accept a form as a parameter and pass in the form that you want eg.

public sub ProcessForm(byval frm as Form)
   <do your stuff here>
end sub

Call it like this: ProcessForm(frmorders)

Regards,

Patrick

 

[Golom]

In the argument list you can pass a reference to the calling form and pick up its Name property. You can also reference a control on the form, either by referencing it through the form or by passing it directly. For example
[tt]
Public Sub mySub ( frm As Form, ctl As Object )

' Get the form name
Dim fname As String
fname = frm.Name
' Reference a control on the form
Dim y As Variant
y = frm.fOptButton.Value
' Reference a passed control
Dim z As Variant
z = ctl.Value
End Sub
[/tt]
and call it with
[tt]
Call mySub Me, fOptButton
[/tt]

 

[bbrendan]

many thanks for your help!