thx 4 your reply, but in the beforeupdate you can't put the value to null.
Like I said before: if requirements aren't met, the afterupdate isn't called. So the afterupdate doesn't work either. The Gotfocus isn't fired at all after leaving dialog boxes opened by the function Msgbox. So that doesn't work either.
User Profile
Collapse
-
howto clear value of unbound textbox on Ms Access form and return focus
I have a form with an unbound textbox and after receiving a value, some checks should be done and maybe even some records inserted in the subform. All of that is going well, but the problem is that whatever happens, the textbox should regain focus and should be clearde. I can do either one or the other, but I can't seem to get both tasks done at the same time.
Returning the focus: I can manage via the beforeupdate event
Clearing...
No activity results to display
Show More
Leave a comment: