Auto complete multiple fields
I have created a database with 17separate fileds for the description of wall motion. These are popultated via a value list which contains six variables. The most common value for these fields is normal.
To simplifiy the data entry process i would like a field or button to select as "all normal" , this would then populate all the 17 fields with the value"normal". If the "all normal" is not selkected then i would like to individually poluate the 17 fields with the appropriatte descriptoe from the drop down value list.
Any assistance would be apprecitated.