Auto Fill a form

[Suzemt]

I would like a field on a form to auto fill with a phrase after I have entered data into another field.



So if I type Yes and field A then Field B updates to Not Decided. If I type No in field A, then Field B updates to Not Applicable.

Any ideas?

Thanks in advance.

[alcapps]

use the after update events on the fields

fieldA after update event
select Case me.fieldA
Case = "Yes"
me.fieldb = "not decided"
Case = "No"
me.fieldb= "Not Applicable"
end select

give it a try..

you could use 2 if statements as well..
or a if and else if as well.
or a if and else only.. if you know this is only a Yes and no option
if me.fieldA = "Yes"
me.fieldB = "ND"
else
me.fieldB = "NA"
End if

[Suzemt]

use the after update events on the fields

fieldA after update event
select Case me.fieldA
Case = "Yes"
me.fieldb = "not decided"
Case = "No"
me.fieldb= "Not Applicable"
end select

give it a try..

you could use 2 if statements as well..
or a if and else if as well.
or a if and else only.. if you know this is only a Yes and no option
if me.fieldA = "Yes"
me.fieldB = "ND"
else
me.fieldB = "NA"
End if

Absolute Genius. Thank you so very, very much.

[Suzemt]

Absolute Genius. Thank you so very, very much.

Could you just tweak it slightly to that I can do exactly the same but fieldb would be on a different form?

Thanks in advance