If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
will try this and update you after..
"Rick Brandt" wrote in message ... "ym" wrote in message ... Hi Rick, I looked at the Tab Order box, the order of the controls right now is set to first the top and then left to right in order of controls layout on the form is Design Mode. In my code, here is how I set the tabindex. Sub TYPE1 DoCmd.OpenForm stDocName Forms![Adverse Reaction Report]!trackingnumber.TabIndex = 0 Forms![Adverse Reaction Report]!txtDate.TabIndex = 1 Forms![Adverse Reaction Report]!cboSourceType.TabIndex = 2 Forms![Adverse Reaction Report]!cboSourceName.TabIndex = 3 Forms![Adverse Reaction Report]!txtSourceNumber.TabIndex = 4 Forms![Adverse Reaction Report]!txtRCTrackingNumber.TabIndex = 5 ...... ..... End Sub You mentioned set the order from highest to lowest. I do not know what is this - could you explain please. What I meant is you could try... DoCmd.OpenForm stDocName Forms![Adverse Reaction Report]!txtRCTrackingNumber.TabIndex = 5 Forms![Adverse Reaction Report]!txtSourceNumber.TabIndex = 4 Forms![Adverse Reaction Report]!cboSourceName.TabIndex = 3 Forms![Adverse Reaction Report]!cboSourceType.TabIndex = 2 Forms![Adverse Reaction Report]!txtDate.TabIndex = 1 Forms![Adverse Reaction Report]!trackingnumber.TabIndex = 0 I don't know if that will make any difference, but often the reshuffling caused by changing an ordinal setting causes problems unless you traverse them backwards. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Form's datasheet view - sort order problem | Simon Wong | Using Forms | 7 | October 18th, 2004 02:28 PM |
Wrong sort order of report's details section | dsjohn_242 | Setting Up & Running Reports | 6 | July 12th, 2004 10:21 PM |
Inhereting the sort order | Dan St.John | Setting Up & Running Reports | 1 | July 9th, 2004 03:30 AM |
Adding auto-numbered field screws up Table order | Carl | Database Design | 5 | May 30th, 2004 03:25 AM |
Pointless rant about order of terms in functions | Pete McCosh | Worksheet Functions | 8 | March 17th, 2004 04:37 PM |