Referencing a form using a variable for the form name

[ejamnadas]

I have a Function in a Module that takes in a parameter. From my form, I call that function and pass my form name. I'm trying to use forms!formname.Controls in the function and I get the error:

Access can't find the form 'FormName' reffered to in macro express of vb code

The code in the form that calls the function is:

Check_Req_Fields "tbAddDocument"

And the code in the function:

Function Check_Req_Fields(FormName As String)

For Each ctrl In Forms!FormName.Controls
If TypeName(ctrl) = "TextBox" Then
If ((IsNull(ctrl.Value)) Or ctrl.Value = "") And (ctrl.Tag = "req") Then
err = err + 1
MsgBox "Please enter a value for " & ctrl.Name
Exit For
End If
End If
Next ctrl


Thank You

[Stewart Ross]

There is an error in the way you are accessing the forms collection - it should be Forms(formname) to use the value of your formname variable, not
forms!formname, which will try to access a (nonexistent) form called formname. The variable's value cannot be substituted for the name of the variable when referring to forms using the ! notation.

-Stewart

[ejamnadas]

Thank you for pointing that out Steve. I do appreciate it.

Elesh