Field based on check box

[hnunez4399]

Good morning to all.
How can I set up an input field on a form to default a number 1 but allow that qty to changed based on a check box with a different qty....

For example I can have 3 check boxes.

qty 6
qty 12
qty 24

When the form opens the first record would default to 1. All records after this would continue to be one unless one of the check boxes for one of the 3 qty's above was selected. If one of those was selected, all the records from that point on, would now use that qty as the default value until it was changed or the form was reopened?

Any help would be appreciated.
Thx

 

[Remou]

I suggest you use an option group and Select Case.

Select Case Me.fraQuantity
   Case 1
      Me.txtQty=6
      Me.txtQty.DefaultValue = 6 'Or is it "=6" ?
   Case  <...>
   Case Else
      Me.txtQty=1
      <...>
End Select