A set focus question 1

[TerryEA]

Hi all

I have an Orders Form and an Order Items sub form. I have "Add" command buttons in both so that the user can add a new order, or add a new item to an existing order. On the sub form I can obviously put code in the On Click event of the button to set the focus to a particular field, to make that the first field when adding a new item. This works OK.

Code: Me![Stock_Code].Setfocus

However, when the user enters data in an item in the subform, he may not fill out all the fields at that time and may stop at, say, field no 6 in the tab order. If he then goes to "Add a new Order", enters main form data data and then tabs to the subform to enter item data the focus is where the user last stopped. I don't seem to be able to set the focus back to the first field in these circumstances.

I've tried the On Current, On Activate and On Got Focus events of the subform, and used the same code as I used in the Add button (which does work) but it doesn't reset the focus.

Which event should I use? or is there another way?

Terry

 

[TheAceMan1]

How are ya TerryEA . . .

In the [blue]On Enter[/blue] event of the subform control:

[blue]   [[purple][b][i]subFormName[/i][/b][/purple]].Form!Stock_Code.SetFocus[/blue]

See Ya! . . . . . .

Be sure to see FAQ219-2884:

 

[TerryEA]

Hi TheAceMan1

Yeh, that did it. Cheers mate.

Terry