Macro or expression

S

Stephanie

In my form, I have an unbound combo box. Then I have start and complete
dates. Those are bound to several fields but it depends on what is selected
from the combo box.

I tried an expression: =IIf([Action]="Redlines","Redline_Recvd")

If Redlines is selected from the combo box, then the start date would have a
control source of field Redline, if Initial Edit is selected, then the start
date would have a control source of field Start Edit. Confused?

Me too.
 
O

Ofer

On the after update event of the combo you can write the code

If me.ComboName = "Redlines" then
me.FieldName.ControlSource = "Redline_Recvd"
else
me.FieldName.ControlSource = "Start Edit"
end if
 
Top