Solved Object Required

[hucheunghugo]

        Y = DLookup("RankID", "staff", "StaffID =" & X)
        If Y = 3 Or Y = 4 Then
        DoCmd.OpenForm "Jrmenu"
        ElseIf Y = 5 Then
        DoCmd.OpenForm "Srmenu"
        ElseIf Y = 6 Then
        DoCmd.OpenForm "Bossmenu"
        Else
        Msg.Box "Permission Needed", vbCritical, "ermission NeededPassword Required"
        Me.PW.SetFocus

        End If

It shows Object require

 

[theDBguy]

Which line?

Try removing the dot between Msg and Box.

 

[hucheunghugo]

Which line?

Try removing the dot between Msg and Box.

MsgBox

 

[theDBguy]

MsgBox

Please my edit. Sorry.

 

[hucheunghugo]

Which line?

Try removing the dot between Msg and Box.

Oh it fixed Thanks a lot

 

[theDBguy]

Oh it fixed Thanks a lot

You're welcome. Good luck with your project.