Allow function to be called by multiple forms 1

[48Highlander]

I have a function in a module that will be called by one of three forms. The control names I am interested in referencing on all three forms are the same. I was hoping to cut down on the amount of code by using something like the following:

If frmName & ".cboEntityType.Column(1)" = True Then
   [COLOR=green]' some more code[/color green]
endif

where the form name (frmName) is one of the variables of the function call.

This doesm't work so does anybody have a nifty code trick for me?

Bill J

 

[PHV]

Perhaps this ?

If Forms(frmName).Controls("cboEntityType").Column(1) = True Then

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[48Highlander]

Sometime I can't see the forest for the trees. Thanks for your help ONCE AGAIN PHV!

Bill J