<div>
<div class="content wysiwyg-content">
I have access subform. This has 8 fields. I want all fields to default to something if first field is selected to be &quot;X1&quot;. If any other value is selected in first field no default should happen.<br />
<br />
Is this possible. Note first field value is only on the form, its not saved in database yet.
</div>
</div>


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.

Defaulting values in access subform ?

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.