Auto Fill in a text box

  • Thread starter Thread starter SheepDog
  • Start date Start date
S

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.
 
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.
Click to expand...

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!
 
Back
Top