Simple IIf statement Problem involving multiple combo boxes Pt. 2

[robbro]

Ok, I've now shortened the statement and updated the "or" operand properly to:

=IIf([Equip Status]="N/A" Or [Equip Status]="Accepted",[Review Status]="Reviewed",[Review Status]="Not Reviewed&quot

Now I dont get an error, but my "Review Status" TextBox does not update to "Reviewed" or "Not Reviewed".

Again, the statement is located within the form on the Equip Status Combo Box (Event -> On Update). The combo box details are Row Source Type = value list and Row Source = N/A;Accepted;Not Accepted.

Why is my Review Status Text Box not updating?

Thanks again.

 

[CajunCenturion]

You might try this:

[Review Status]=IIf([Equip Status]="N/A" Or [Equip Status]="Accepted","Reviewed","Not Reviewed")

Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[Rolliee]

It is easier to leave off part of the name of variables but not the greatest of practice. The old timers would shake their fingers at you. Take the time to put 'me.' in front of the fields and variables to be sure the compiler does not think it is a simple variable.

Also in debugging use some booleans like okay

okay = = ([Equip Status]="N/A" ) Or ([Equip Status]="Accepted&quot

if okay then
....
else
...

endif


Then you can slip in a msgbox to see what is happening.

Rollie E