Tab control sequence

[Spot On]

How do I code a tab control sequence?
After selecting a customer Name in my Main form, it automatically tabs to my productID in a subform which is in a tab page (named sales details). After the line/s items have been completed it auto tabs to the next field Booking date on the next tab page (named rebooking) and so on
Thanks Peter

 

[RuralGuy]

Are you describing what you have or what you want? Does everything take place on the SubForm with the Tab control?

 

[missinglinq]

Like Allan, I don't really see a question here, Peter! It reads like an explanation of what you already have in place, and not a very clear explanation at that. Perhaps a little clarification is in order.

 

[gemma-the-husky]

you can set the tab order for all the controls, simply by right-clicking (either the form, or the forms control box - i forget which) to get the tab order list

you can also turn off any control, so that it doesnt accept a tab

 

[Spot On]

Sorry for the lack of communication!
What I need the tab sequence to do is - After selecting a customer Name in my Main form, I then tab direct to my productID in the subform which is in a tab page (named sales details).

Eg:Line
ProductID = Hair Cut
Qty = 1
UnitPrice = $99
Discount = $15%
Discount Reason = VIP
TotalPrice = $84.15
StaffInitials = PR

I then tab thru the next line which will be all empty due to no further purchases, and on the last field "Staffinitials" the next tab goes to the field Booking date on tab page (named rebooking) which is in the subform as well and so on.

I have turned off all the tabs I dont need both in the main form And sub form.
What it is doing now is When I select customer name (Main Form) hit tab control it tabs to the Sales Details Name on the tab page, I hit tab control again it goes to the ProductID in the subform (within the Tab Page "Sales Details)) I enter the required data in the fields and tab control thru the next line all being no data as soon as i tab control off the field "staffinitials" it bounces back to the customer name in the main form
Hope this explains
Peter

 

[RuralGuy]

Are you doing anything special to get the focus from the [customer name] control to the SubForm? You could put code in the OnExit event of that control to put the focus wherever you want. Just be aware that moving the focus from a MainForm to a control on a SubForm os a two stage process: 1st to the SubFormControl and then to the control on the SubForm.