Recent content by EMN

HI Minty, I have tried this but its still not putting the focus on the txtdate textbox. (1) I have commented out the txtWo as this is the next text box (2) User enters an invalid date in the txtdate textbox - so they get the error described = correct (3) The field is then cleared upon...

Hi, Thanks for the reply, I have tried this and am getting an error "Compile error- Procedure declaration does not match description of events or procedure having the same name" I put the code before the UpdateAfter. I called DIM txtdate as Integer also but it doesn't make a difference...

HI, Thanks for your replies but the Me.txtdate.Text = "" and the Me.txtdate.SetFocus don't make any difference. I have commented out the Cancel = True in the afterupdate section- this too has made no difference. I don't have a beforeupdate - I did try creating a beforeupdate with the same...

Hi, I'm having trouble setting the focus on a date text box in VBA. I have performed error handling which will prevent the user enter an incorrect date format. I have tried several options from .setfocus etc but nothing seems to work, and trying to set the focus to another text box first then...