Error on login form

[Guest]

I have a query as the Record Source of a login form.

I placed the following code at the end of the Click Event on the submit
button:

If Me.CU.Value = "Yes" Then

MsgBox "You have Uncompleted Requests - Please review and update."

End If

I know the value of CU is Yes as it is currently visible on the form when I
open it. However, I get the error "The expression you entered refers to an
object that is closed or doesn't exit."

Where am I going wrong?

Thanks.

 

[Guest]

Hi Gary,

Is this the line that is actually producing the error or is there follow-up
code which creates the error.

Try the following line:

If Me.CU = -1 then .....

instead of If Me.CU.Value = "Yes"

hth