I have access subform. This has 8 fields. I want all fields to default to something if first field is selected to be "X1". If any other value is selected in first field no default should happen.
Is this possible. Note first field value is only on the form, its not saved in database yet.