I am trying to load a form without showing it, when another form (my primary form) loads. This is because the second form is slow to load and I would rather have the delay while the initial form is loading.
I have used this code:
Private Sub Form_Load()
Dim ObjName As Object
Set ObjName = ClientMenu
Load ObjName
End Sub
But it fails with a data type mismatch error. It seems I am not referencing the form name correctly.
I am now using:
DoCmd.OpenForm "ClientMenu", acNormal, , , , acHidden
as a substitute, but the second form appears briefly on the screen during loading, which I would prefer to avoid. (Doesn't look too professional!)
Any assistance would be welcome.
I have used this code:
Private Sub Form_Load()
Dim ObjName As Object
Set ObjName = ClientMenu
Load ObjName
End Sub
But it fails with a data type mismatch error. It seems I am not referencing the form name correctly.
I am now using:
DoCmd.OpenForm "ClientMenu", acNormal, , , , acHidden
as a substitute, but the second form appears briefly on the screen during loading, which I would prefer to avoid. (Doesn't look too professional!)
Any assistance would be welcome.