Tab Order Problem

[Mahavir]

i have problem in attaached database in the form frmAdvice. the problem is in tab order. when i start enter the record using this form first record will be in tab order which i want but in second time forcus to the field amount instead of PO_No (Subform). kindly help.

[Robeen]

The Tab Index property for the AMOUNT field is set to 0.
This means that that is the first place the cursor will go when the sub form gets focus.
AdviceId is set to 6, PO_NO is set to 5 . . .
Change the Tab Index property of those text boxes depending on the order in which you need the focus to move.
All the best!

[Mahavir]

Thanks for reply. actully by mistake i attached previouse version in which tab order was totaly reverse. now i am attaching the latest in which i changed already the tab index property as per ur suggestion but still the problem is same.

The Tab Index property for the AMOUNT field is set to 0.
This means that that is the first place the cursor will go when the sub form gets focus.
AdviceId is set to 6, PO_NO is set to 5 . . .
Change the Tab Index property of those text boxes depending on the order in which you need the focus to move.
All the best!

[Robeen]

I opened your second database - everything seems to be working as expected.
When I open frmAdvice - the focus is on Advice Date and then - when I Tab - the focus goes in this order:
Client
PO_NO
PO_DATE
INVOICE_NO
INVOICE_DATE
DESCRIPTION
AMOUNT

I created a new Advice number [286] and then went to the sub form and entered three new PO_NO's / Invoices . . ..

The Tab order worked perfectly.

I could not reproduce the problem you are describing.

[Mahavir]

Hey robin thanks for reply again,

as you said first entry is fine like u have entry 286 but when we enter second entry immidiatly after, it goes to amount field. this is the problem..

Mahavir

I opened your second database - everything seems to be working as expected.
When I open frmAdvice - the focus is on Advice Date and then - when I Tab - the focus goes in this order:
Client
PO_NO
PO_DATE
INVOICE_NO
INVOICE_DATE
DESCRIPTION
AMOUNT

I created a new Advice number [286] and then went to the sub form and entered three new PO_NO's / Invoices . . ..

The Tab order worked perfectly.

I could not reproduce the problem you are describing.

[Robeen]

I entered 287, 288 & 289 - and entered invoices for each one of those - and I still got the Tab order working correctly.

I could not reproduce your problem.

Can you explain again exactly - step by step - what you do to get your problem?

The Tab order on your form & subform work correctly for me.

[Mahavir]

my problem is when i open the database and start entering advices, first entry goes in fine order as i want but second time, after selecting client tab should be go to PO_No but it is going to Amount field that i dont want it should go to PO_No.

I entered 287, 288 & 289 - and entered invoices for each one of those - and I still got the Tab order working correctly.

I could not reproduce your problem.

Can you explain again exactly - step by step - what you do to get your problem?

The Tab order on your form & subform work correctly for me.

[Robeen]

I was finally able to re-create your problem.

I don't know what is causing the problem - sorry!

But . . . to correct this problem, I did the following:

1. Select the cmbClient combo box on frmAdvice.
2. Open the Property Sheet & click the Events Tab.
3. Click in the 'On Lost Focus' field, click on the ellipsis [...] on the right and select 'Code Builder'.
4. Paste this into the subroutine:

 
Me![AdviceDetailSubForm].SetFocus
Me![AdviceDetailSubForm].Form![PO_NO].SetFocus

Your code should look like this:

 
Private Sub cmbClient_LostFocus()
 
Me![AdviceDetailSubForm].SetFocus
Me![AdviceDetailSubForm].Form![PO_NO].SetFocus
 
End Sub

This will ensure that every time you select a ClientId, you will go to the PO-NO box on your sub form.

Let me know if that works!

[Mahavir]

its working man... thanks a lot.....

[Robeen]

You're welcome!
Mark it as solved by going to the Thread Links at the top of the page!