control conditional default value

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?
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top