control conditional default value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm new to access, and have muddled my way through setting up a database
(tables, queries & forms). I have a control on a form in which I'd like to
make the default value displayed conditional on the value of a previous
field. I have tried using the following IIF statement in the default value
property of the control:

=IIf([Ctrl1]="ABC","DEFG",Null)

However, when the value of the Ctrl1 control = ABC, the default value of the
"conditional" control is still blank.

Any ideas?
 
Me again, I just did a less "filtered" search and found the answer to my
question in a previous post. Thanks anyway.
 
Back
Top