Form as constant

[OraMs]

Yes, I know an object cannot be a constant. However, I need some way of having a "constant" form.

Here's my scenerio. I call a function from multiple controls and I pass the form and the control name.

The function is declared as follows:

Function CtrlNavigation(frmName As Form, ctrlName As String)
On Error GoTo ERROR
    
    Select Case ctrlName.NAME
        
        Case "Control1"
                .
                .
        Case "Control2"
                .
                .
        Case "Control3"
                .
                .
        Case "Control4"
                .
                .
        Case Else
                .
                .
    End Select
ERROR:
    MsgBox Err.DESCRIPTION
End Function

I need to use other controls on the form within each case statement.

I do not want to type the form name each time I call the function.

Any suggestions?? Thanks in advance for your time.

 

[jebry]

Hi!

What you probably want to do is use the Screen object. A few of the properties of the screen object which will be useful for you are: ActiveForm, ActiveControl, PreviousControl. From these you can get the name of the form and use the to loop through the controls on the form to get the information you need, or set up a select case based on the form to access the controls you need. Using the screen object you will not need to send the function any information.

hth Jeff Bridgham
bridgham@purdue.edu