Set the control in focus

[ScottXe]

I tried to set the focus in the previous control "txtAdd" without success. Can someone advise me why it does not work in the after update event of txtAdd control in the attached demo file. Thanks!

[Bob Fitz]

I tried to set the focus in the previous control "txtAdd" without success. Can someone advise me why it does not work in the after update event of txtAdd control in the attached demo file. Thanks!

Can't explain why it doesn't work but if you put your code in the Got Focus of the next control ( txtModel ) it seems to work.

[ScottXe]

Can't explain why it doesn't work but if you put your code in the Got Focus of the next control ( txtModel ) it seems to work.

Hi Bob,

It works after I place the set focus statement into Got Focus of txtModel control. Never thought this way to resolve it. Thanks a lot.

[Missinglinq]

I tried to set the focus in the previous control "txtAdd" without success. Can someone advise me why it does not work in the after update event of txtAdd control

This is just one of those Access quirks! To get Focus to stay in a Control, if some validation on the entered data fails, you have to use the Control's BeforeUpdate event, and set Cancel = True. This stops the update of the Field and leaves Focus in the Control.

Private Sub txtAdd_BeforeUpdate(Cancel As Integer)
  ' If Validation Code fails
  'Messagebox warning to user
  Cancel = True 
End Sub

Linq ;0)>