Populating another field based on a checkbox

[Alaska1]

I have two fields. One is a checkbox and the other is a text field. when the checkbox is checked I want the other field to populate with text.

Field Names
DataEntry
PayrollErrorOccuredCheck - Check box field

Once the checkbox field is checked, I need the text box to be populated with payroll error occured.



What is the best way to do this?

[RuralGuy]

I would hope both of these controls are not also bound to fields in the same table. That would be redundant and unnecessary. You can place anything you want in the TextBox using code in the AfterUpdate event of the CheckBox. Since a CheckBox is a toggle, what do you want to happen if it is clicked twice thereby unchecking the CheckBox?

[Alaska1]

I would hope both of these controls are not also bound to fields in the same table. That would be redundant and unnecessary. You can place anything you want in the TextBox using code in the AfterUpdate event of the CheckBox. Since a CheckBox is a toggle, what do you want to happen if it is clicked twice thereby unchecking the CheckBox?

I have the a field for the Check box and a field for Pay Error Occured in a table. If clicked twice I would like the text to be cleared.

[RuralGuy]

As I said, these fields are redundant so only one is necessary but here's code for the Click event of your CheckBox:

Private Sub chkBox_Click()
If Me.chkBox Then
    Me.txtBox = "Payroll error occured"
Else
    Me.txtBox = ""
End If
End Sub

You of course need to use your names for the chkBox and txtBox.

[Alaska1]

As I said, these fields are redundant so only one is necessary but here's code for the Click event of your CheckBox:

Private Sub chkBox_Click()
If Me.chkBox Then
    Me.txtBox = "Payroll error occured"
Else
    Me.txtBox = ""
End If
End Sub

You of course need to use your names for the chkBox and txtBox.

Thank you. The code worked. Appreciate your help.

[RuralGuy]

Did you want to go ahead and use the Thread tool and mark this thread as Solved?

[Alaska1]

Did you want to go ahead and use the Thread tool and mark this thread as Solved?

Thank you! I marked it solved

[RuralGuy]

Thank you. Say hi to Sarah for me.