form field

[new_to_access]

How can I create a form field when it generates automatic information when data is entered in a previous field?



For instance:

If on field 1 I enter 001 than field 2 should automatically show a

If on field 1 I enter 002 than field 2 should automatically show b

Thanks!

[pbaldy]

You can use the after update event of the first control to set the second. Based on your simple example you'd use an IIf(). I suspect your real situation is more complicated.