Can't assign value to object

  • Thread starter Thread starter andrew3254
  • Start date Start date
A

andrew3254

Hello,

I have a text box on a form which gets filled in when it is opened dependant
on who is logged on. The code I have works for other forms but not this one
and I am hitting a dead end trying to fix it. Here is my code:

If CurrentUser() = "User1" Then
Me.Division = "Division1"
Else
Me.Division = "Division2"
End If

I just keep getting run-time errors saying the value cannot be assigned.
The data is not an aggregate, it is a bound text box there is no default
value.
 
Odd things can happen when a control and a field have the same name. I
don't know if that is the case, and I sort of doubt it will matter if it is,
but if they are the same name (and if the recordset can be updated, as
mentioned in another response) you could try changing the control name to
something like txtDivision. The code wouldn't have to change.
 
Back
Top