In the last part of my question
Here mbizup suggests
" If there is a sub or function that I need to use across multiple forms, I generally will place it in a separate public module. You can pass form and/or control names to public functions as needed. "
My question...
Is there an example somewhere of passing Form and control names through or to a public function?
Function/Sub:
Sub LockControls(strFormName as string)
Dim frm as form
Set frm = Forms(strFormName)
frm is now a form object and you can access it's methods and properties. ie.
If frm.visible = True then
Jim.