Hi

Please help with what I thought would be a simple operation. My main form has contact details and my subform has company details. I have set the tab order so that when needed the user can enter company details if required but when they reach the end of the subform instead of continuing in the fields in the main form as I intended the subform starts a new record. I can point the mouse at the required text box and continue but I want to be able to tab out of the subform and continue entering data in the main form. My ability is somewhat limited (as you can probably tell) but all help will be most welcome.

Kind Regards

Mudpuppy

Where you want it to tab out of the sub form use "SendKeys" (See Help for more info)

You will want to send ctrl+Tab to exit a sub form.