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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

R5 - Automate drop down value based on another field

Status
Not open for further replies.

JoseQuiervo

Programmer
Sep 25, 2002
57
US
I have varioud drop downs (1 @dbcolumn, and 4 @dblookup's based on what the @dbcolumn displays). How can I get it so that when the user selects a value for the @dbcolumn drop down, the other 4 fields are automatically populated?

Thanks
 
Enable the "Refresh Fields on Change" option in the @DbColumn field.
That should recalculate your form and reevaluate the other fields formula. Therefor, if the other fields all use the first one as key value, it will have an impact. Oh, and the other four need to be computed, not editable.
In order to have any impact on an editable field, you have to code it specifically (most often in a button).

Pascal.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top