Hey guys, i got a enquiry here, cant figure it out myself.
I got a textbox field that validates what users input, if the users enters, lets say, less than 10, then the back color of the texfield will turns red, and if the users enter more than 10, it will be reverted back to normal(white background). I wanted the color be be reverted back to normal when the users click to a fresh next record(sort of like clear every fields) and the color will still be red when i previous back the record which fails the validation rule(<10).
Private Sub textbox_AfterUpdate()
if textbox < 10 then
textbox.BackColor = vbRed
text box.BackColor = vbWhite
Currently i am stuck at when users click a fresh new record, the background is still red in the fresh new record.
Thank you for the patience.