Opening a form from 2 locations

[pomster]

I am trying to open a form from 2 other forms a different times but am getting "type mismatch error" with this:-

Public Function GetMemNo() As Long

If IsLoaded(Forms!f_membership) = True Then

        GetMemNo = Forms!f_membership.lngMembershipNo

Else
        GetMemNo = Forms!f_selectfish.[List0]
End If

End Function

Can somebody please help.

regards,


David

CRXIR2 with CRXIR2 server and SQL 2005

 

[TheAceMan1]

How are ya pomster . . .

Try:

[blue]If IsLoaded("f_membership") Then[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[pomster]

Ace Aceman... yoo da best!!

regards,


David

CRXIR2 with CRXIR2 server and SQL 2005