Combo box problem

[Russ]

I have two combo boxes: "DayShift" and "NightShift". The
values are (1) and (2) for "DayShift", and (3) and (4)
for "NightShift.
What I'd like to see is if the value of (1) is selected in
combo box: "DayShift" I'd like for the only selection in
combo box: "NightShift" to be (4)

The same should be true for if "DayShift" value is (2),
the only available value in combo box "NightShift" should
be (3).

Any ideas will be appreciated.

Thanks,

 

[Marshall Barton]

Considering only the IIf statement you have posted - your
sintax is not quite correct. The syntax for the statement
is:

IIF ([this is true], [do this], [otherwise do this])

With that in mind your statement should probably look
something like this:

IIf([Forms]![frm_RoboCoater_3_Rinse_Tank_Temperature]!
[cboDayShift]=1,4,3)

Right! That's what I said ;-)