Set focus when pop up form closes

[projectpupil7]

Hi, I am trying to set the focus back to page 1 of TabCt186 when pop up form frmEditWorkItem closes on clicking a command button.

I have been trying with this line of code but keep getting asked for an object required.

Forms!frmReactiveTracker!TabCtl86.Pages.Item(1).Se tFocus



Could someone put me right here please.

Many thanks

[burrina]

What is Item(1) and your also put a space in SetFocus
Try instead:

Forms!frmReactiveTracker!TabCtl86.Pages(1).SetFocu s

[ssanfu]

Forms!frmReactiveTracker!TabCtl86.Pages.Item(1).SetFocus

and

Forms!frmReactiveTracker!TabCtl86.Pages(1).SetFocus

Both forms of the command work for me.

Is the form frmReactiveTracker open?
Check spelling of form name and tab control name.....


Or post your dB for analysis.

[projectpupil7]

Hi Steve, many thanks for your reply. I am now slightly embarrased as when i copied and pasted your code in to my db it all worked as required. I don't know what the problem might have been as my code and yours look the same. Anyway, all is well now. Thanks again.

[projectpupil7]

Thanks burrina. i think this is one of those unexplainable issues. ssanfu suggested an answer which worked.

FYI Item(1) is supposed to represent the tab page number and SetFocus was just a typo or copying error.

Many thanks for you interest.