Keycode and setfocus issue

[neelsfer]

I have a problem to reset the focus to a specific field in a subform, when i press the escape button on the keyboard using the following vba. This field is a lookup field.

Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
If KeyCode = 27 Then
        DoCmd.CancelEvent
         KeyCode = 0
     Forms!Fis_OrderICNSF.SetFocus
      Forms!Fis_OrderICNSF!Item_Lookup.SetFocus
        End If

Any suggestions pls

[TheSmileyCoder]

As always, please describe what is happening currently. Does the code even run?

[neelsfer]

Sorry, it does not set the focus back to the item_lookup field in the subform, when it clears the row after pressing Escape

[TheSmileyCoder]

TheSmileyCoder
Does the code even run?

Please make sure to answer those questions asked for you. Otherwise you will find that people rapidly loose interest in the thread, if they have to drag the required information from you.

[NeoPa]

Please also explain how the various items in your question relate to each other.

1. What is the name of the main form involved?
2. Is the code running from the main form or the sub-form?
3. What is the name of the subform control as well as the form contained within it?
4. What is the name of the control that focus is on when you tested this code?

With all that information we will be in a position to answer your question. Having it in your question post already is always a very good idea.

PS. If [Fis_OrderICNSF] is the name of your sub-form's form, then the Forms!Fis_OrderICNSF reference will not work (See Referring to Items on a Sub-Form).

[neelsfer]

Apologies
main form is OrderingF
Sub-form = Fis_OrderICNSF
main control : Item_Lookup
Focus stays in "quantity" field after Escape is pressed and row cleared

What i would like to do is when i press Escape on the keyboard after the row had been added, the row must be cleared and the focus must return to the original field called "Item_lookup, where i searched for the item to be captured. Currently when an Item has been added, the focus goes to the next field called "Quantity" in the subform and it stays there even after the row has been cleared(deleted).
Hope it is clearer now.
thx

[NeoPa]

That is much clearer now Neels, but you've missed out two items requested. I doubt you'll catch me now for a few hours, but with that extra information many experts will be able to help, and I'll be looking at it again when I next can too.

[Rabbit]

If it's a subform, it doesn't get added to the Forms collection. Therefore you can't reference a subform using Forms!subFormName.controlName. You need to use Forms!mainForm!subFormControlName.Form.controlName. You may or may not need that Form reference, I can't remember off the top of my head, try both.

[NeoPa]

Rabbit:
You need to use Forms!mainForm!subFormControlName.Form.controlName . You may or may not need that Form reference, I can't remember off the top of my head, try both.

To clarify that point, as the control on the form (any form) is no part of a SubForm control, something must specify that it is the Form object that is the next part of the reference. this can be done explicitly (...subFormControlName.Form.controlName) or by inference (...subFormControlName!controlName).