I use this code to create a set of records:
For i = 1 To Me.txtQuantity
![Part_No] = Me.cboPart_Number
![Label_Date] = Me.txtDate_Created
![Serial_No] = Me.txtSerial_Number_Start
![Operator] = Me.cboOperator
![Work_Order] = Me.txtWork_Order
![Date_Code] = Me.txtDate_Code
![Notes] = Me.txtNotes
If Me.cboPart_Number = "PS395" And Me.chkR = True Then
![R] = True
Me.txtSerial_Number_Start = Me.txtSerial_Number_Start + 1
It all works except the IF statement.
The line: ![R] = True
is executed, but the record is not updated in the table.
The field "R" is a Yes/No field.
Is there a problem with naming a field with a single letter as I have here? "R"