Greetings again,
This appears simple enough, yet it isn't working.
I have 2 fields, one called status and the other called state.
Status has 2 values, Open or Closed
'State has several values in dropdown. One of those values is Active.
So, let's make sure Status is not blank
'then check whether open or closed. If open, then state should be active, otherwise, just assign whatever db value is available including blank.
If not Isnull(Status) or Status <> "" Then
If Status = "Open" Then
State = "Active"
else
State = request.form("State")
end if
End if
So far, the State is not changing to Active when Status is open or to some other value, including blank value when status is CLosed.
Any ideas?
Thanks a lot as always
