Message box that will ask you to provide user information if you click save

[Jodeny]

I'm using this code to either ask for user information if not provided OR save the user info if available BUT when i click on my command button save, i get this message when no info is provided,"New User has been successfully added"

Private Sub cmdSave_Click()
If UserId = "" Or Password = "" Or UserName = "" Or AuthorityLevel = "" Then
    
    MsgBox "Complete User Information NOT Provided"
    Else

DoCmd.Save
DoCmd.GoToRecord , , acNewRec
 MsgBox "New User has been successfully added"
End If
End sub

[Rabbit]

Are you sure the default values are blank strings? Or are they nulls? Usually if no data has ever been entered, the value of the field will be null, not a blank string as you have it.

[Jodeny]

The default values are null.

[zmbd]

Then per Rabbit, you need to test for Null values as the double quote is not the same.

[TheSmileyCoder]

Assuming you have a textbox on your form by the name of tb_Username, there are 2 ways to test it for :

If Me.tb_UserName & ""="" then

works since Null & "" is equal to ""
Another way is:

IF Nz(Me.tb_UserName,"")="" then

The NZ function is used to convert a null value to a safe value, or a default value if you wish.