Tab Order with subforms and subdatasheets (1 Viewer)

[Kozbot]

Hello

I have a continuous form with a bound subform in the footer section. Is there a way (with VBA?) to set the tab order so that it tabs down to the subform in the footer after a few controls in the main form and then back to the main form after going through the subform?

Also I have a form with a subform in datasheet view. Can I have the tab order set so that it tabs through a few fields in the datasheet view, expands the subdatasheet and allows you to tab through it, then tab back to the main datasheet?

I want users to fill out a few fields in the main form, go the subform easily, enter the data there, then go back to the main form easily and enter the rest of the data before going to the next record in the main form.

Thank you!

 

[rzw0wr]

Try,
In the AfterUpdate event
Forms!YourMainForm!YourSubForm!Control.Setfocus

Leave the SubForm out to return to your Main form.

Dale

 

[Kozbot]

Try,
In the AfterUpdate event
Forms!YourMainForm!YourSubForm!Control.Setfocus

Leave the SubForm out to return to your Main form.

Dale

Thank you!

This works for the first problem but does not work in datasheet view