LostFocus in subform not firing

[AngelB]

Hi All,
I have a subform containing a product and a
'number-of-sales' field. On the main form the user enters a financial period and a market area, then all products relevant to that data are displayed in the subform. I have put some code in the lostfocus event of the product code textbox on the subform, but when I tab out of this box nothing happens. If I click back into it then out again, the code fires.

Does anyone know why this is happening and how I can make the code execute on the first tab-out?

Thanks

Geraint

 

[PhilH123]

Hi Geraint,
If you are leaving the subform when you tab out of the control the lostfocus event does not occur, try moving the code to the exit event and see if this works.

I've had trouble with subforms in the past and it's usually easier to find a work around than dig out an explanation of why things are happening.

Hope this helps,
Philh123

 

[AngelB]

Thanks Phil, I wasn't leaving the subform when tabbing out of the control but the exit event works every time.

Thanks

Geraint