[Access 2007] Runtime Error 3219

[Steve B]

I'm using the basic Password Challenge from this MS Bulletin

http://support.microsoft.com/kb/209871

I have a FE \ BE based database but I'm Getting the error "3219" after the
user has pressed submit.

The Password form code is

If IsNull(Forms!frmPassword!Text0.Value) Then
MsgBox "You cannot enter a blank Password. Try again."
Me!Text0.SetFocus
Else
MyPassword = Me!Text0.Value
DoCmd.Close acForm, "frmPassword"
End IfThe error is not present if I load the form and submit on
the backend table. I've never had it before as the database has just been
split due to requests from other users to access the database.

Now I'm slowly learning VBA so does anybody have a Solution and a basic
explanation as to why it happens?

 

[franklin]

I'm using the basic Password Challenge from this MS Bulletin

http://support.microsoft.com/kb/209871

I have a FE \ BE based database but I'm Getting the error "3219" after the
user has pressed submit.

The Password form code is

If IsNull(Forms!frmPassword!Text0.Value) Then
MsgBox "You cannot enter a blank Password. Try again."
Me!Text0.SetFocus
Else
MyPassword = Me!Text0.Value
DoCmd.Close acForm, "frmPassword"
End IfThe error is not present if I load the form and submit on
the backend table. I've never had it before as the database has just been
split due to requests from other users to access the database.

Now I'm slowly learning VBA so does anybody have a Solution and a basic
explanation as to why it happens?