Value of .Value

[libraccess]

I have just checked a DB that had been going fine until a new user installed it with a hiccup and I went looking for the cause



Private Sub LogIn_GotFocus()


If Me.PUName = "1" Then
Me.btnPrivateUser.Enabled = True

Else

Me.btnUserLogIn.Enabled = True

End If

End Sub

PUName is Unbound Control with a row source UserID, NameExpr, strUserPass, if the User selects Private User and has the pass code the Private User Button is enabled UserID is 1 for the name PrivateUser.

So my question is both of the following work (in fact even the "1" has been working so far ?) but the two below work on the new users machine, which of the following would be preferable


If Me.PUName = 1 Then


If Me.PUName.Value = 1 Then

Thanks

[June7]

.Value is default property for data controls. So if it is not explicitly referenced, it is assumed. It may be bad practice but I never bother typing it.

The "1" works because the actual value in the PUName combobox is the numeric UserID.

[libraccess]

Thanks for your reply. Still unexplained why one PC kicks this back. I first changed nothing other than removing the quotes. (it worked) but then posed the question of .Value and that worked too. Oh well I guess I'll change the Code in all FEs to = 1

[June7]

I misread the question about quote marks. I should not have used them in my statement.

Not sure why they would cause error with unbound combobox.