I'd appreciate a steer on a problem. I have 2 numeric fields in a subform, values of which are input by user based on text selected from a dropdown list in another field in same subform. What VBA or other option can I use so that these 2 numeric fields are re-set to 0 (zero) when user changes selection in the dropdon list to "No show". What I've read so far suggests that AfterUpdate can be used but how best to configure with VBA or otherwise? Thanks
Kevin Robertson 2 months ago
You are correct. After Update is the event you need.
This is assuming the first column in your Combo Box is an ID.
If ComboBoxName.Column(1) = "No show" Then
Textbox1 = 0
Textbox2 = 0