Tab

[IanT]

I have a form, with a subform, and a subform within the subform. I want to tab from the last subform to the second subform.

I have tried Forms![sb Scanner activity]![Command43].setfocus in code but it does not recognise the location. Can any one help.

 

[BadOkie]

Hey Ian,

If you trying to set focus in a subform, you will need to do something like:

Form![MainFormName]![SubformName].Form![SubformFieldName]

You can put this in the last fields On Exit or you can put it in the Key Down property and trap that it's the Tab key that has been pressed.

HTH
Shane