Auto Fill in a text box

[SheepDog]

I have text box on a form that I want to auto fill form the entry of
another text box.

If I enter Representative in a txtLegislator I want it to auto fill in
txtLegID SCHH and if I enter Senator in txtLegislator I want it to auto
fill in txtLegID SCHS.

 

[ChadK]

I have the same problem. If you find an answer can you forward it to me
too.

 

[John W. Vinson]

I have text box on a form that I want to auto fill form the entry of
another text box.

If I enter Representative in a txtLegislator I want it to auto fill in
txtLegID SCHH and if I enter Senator in txtLegislator I want it to auto
fill in txtLegID SCHS.

Ummmm... why?

It sounds redundant. If you can unabmiguously determine the value in
this field from the value of another field, you can just calculate it
on the fly whenever you want.

What's the underlying table structure? Remember - forms are just tools
to manage data in tables; if you're starting your design with the form
rather than the tables, you're doing things backward!