Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Update text form field from drop down 1

Status
Not open for further replies.

lespaul

Programmer
Feb 4, 2002
7,083
US
I have a drop down list on a form that contains:
[tt]
COUNTY OF BERNALILLO
STATE OF NEW MEXICO
CITY OF ALBUQUERQUE[/tt]

When the user selects one of those options I have a form field further in the document that I want to have that filled in with:
[tt]
Condado de Bernalillo
Estado de Nuevo México
Ciudad de Albuquerque[/tt]

however I have to actually EXIT the drop down list in order for the text box to get filled in ...is there some kind of 'OnChange' event that i can use to trigger the update of the second form field?

Thanks!
Leslie

 
On the same line...I have two other drop downs that have the same information in different locations...any way I can get dropdown2 to match what is in dropdown1 when something is selected in dropdown1?

Thanks!
Leslie
 
There is no OnChange event for a dropdown formfield (from the Forms toolbar). There is a Change event for an ActiveX dropdown (combobox), from the Controls toolbar.

"any way I can get dropdown2 to match what is in dropdown1 when something is selected in dropdown1?"

Dropdowns are for user to select something. Why do you want to have a dropdown(2), if it is just going to match dropdown(1)? You could use a field that would reflect the value of dropdown1, what ever it was.

faq219-2884

Gerry
My paintings and sculpture
 
DropDown1 is the source dropdown formfield.

1. Make sure Calculate on exit is checked. Right click the formfield, select Properties, check Calculate on exit.
2. Go to where you want to have its value also shown.
3. Press Ctrl-F9. You must use Ctrl-F9.
4. Type the name, "DropDown1" (no quotes).
5. Move the cursor someplace else.

Done. When you tab out of the dropdown (Dropdown1), its value will automatically appear where you put the other field(s).

You can do this as many times, in as many places, as you like.

faq219-2884

Gerry
My paintings and sculpture
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top