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 |
#1
|
|||
|
|||
Setting Focus
I have a form with about 15 subforms for which I have used tabs. I have to
enter a lot of information in each tab, but when I click on the tab the cursor isn't always in the first field, which is where I want it to be. Can you tell me how I set the focus to the first field when the tab is clicked? I am not too knowledgeable about code, so if you provide some, can you tell me where I have to fill in my own information and which propery field it goes into? Thanks much! |
#2
|
|||
|
|||
Setting Focus
Unless you want the focue to be anywhere other than the first tab on the
subform you don't need to "set Focus". Simple open the forms in design view and set the fist field (the one that you want it to open with as the focus) as Tab Index 0. You will find this on Properties - Other. -- Wayne Manchester, England. "Tanya Lee" wrote: I have a form with about 15 subforms for which I have used tabs. I have to enter a lot of information in each tab, but when I click on the tab the cursor isn't always in the first field, which is where I want it to be. Can you tell me how I set the focus to the first field when the tab is clicked? I am not too knowledgeable about code, so if you provide some, can you tell me where I have to fill in my own information and which propery field it goes into? Thanks much! |
#3
|
|||
|
|||
Setting Focus
Tanya -
Go to the Properties and set the Tab Index of the first field to "0" (without the quotes). You will want to order the rest of the fields as well, so go to each successive field and set the Tab Index to 1 higher than the previous field. It's always a good idea to do this on every form because it controls how the user moves through the screen. Tanya Lee wrote: I have a form with about 15 subforms for which I have used tabs. I have to enter a lot of information in each tab, but when I click on the tab the cursor isn't always in the first field, which is where I want it to be. Can you tell me how I set the focus to the first field when the tab is clicked? I am not too knowledgeable about code, so if you provide some, can you tell me where I have to fill in my own information and which propery field it goes into? Thanks much! |
#4
|
|||
|
|||
Setting Focus
Thank you both - that worked perfectly!!!
Follow-up question though...my subforms are all in datasheet format because I have to enter a lot of records in each one. The cursor is now in the first field, however if there are any records, I still have to click because I need to now place my cursor in the first blank field.........I know this changes things...any ideas on how to do this when using datasheet format? Thanks again. "Wayne-I-M" wrote: Unless you want the focue to be anywhere other than the first tab on the subform you don't need to "set Focus". Simple open the forms in design view and set the fist field (the one that you want it to open with as the focus) as Tab Index 0. You will find this on Properties - Other. -- Wayne Manchester, England. "Tanya Lee" wrote: I have a form with about 15 subforms for which I have used tabs. I have to enter a lot of information in each tab, but when I click on the tab the cursor isn't always in the first field, which is where I want it to be. Can you tell me how I set the focus to the first field when the tab is clicked? I am not too knowledgeable about code, so if you provide some, can you tell me where I have to fill in my own information and which propery field it goes into? Thanks much! |
#5
|
|||
|
|||
Setting Focus
You can open the form to a new record so the cursor is there already if
you want. I think you just need to set the Data Entry property of the form to "Yes". You can also try using DoCmd.GoToRecord , , acNewRec Tanya Lee wrote: Thank you both - that worked perfectly!!! Follow-up question though...my subforms are all in datasheet format because I have to enter a lot of records in each one. The cursor is now in the first field, however if there are any records, I still have to click because I need to now place my cursor in the first blank field.........I know this changes things...any ideas on how to do this when using datasheet format? Thanks again. |
#6
|
|||
|
|||
Setting Focus
Thanks a lot!
" wrote: You can open the form to a new record so the cursor is there already if you want. I think you just need to set the Data Entry property of the form to "Yes". You can also try using DoCmd.GoToRecord , , acNewRec Tanya Lee wrote: Thank you both - that worked perfectly!!! Follow-up question though...my subforms are all in datasheet format because I have to enter a lot of records in each one. The cursor is now in the first field, however if there are any records, I still have to click because I need to now place my cursor in the first blank field.........I know this changes things...any ideas on how to do this when using datasheet format? Thanks again. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
setting focus to a field in a subform | Saj | Running & Setting Up Queries | 10 | April 11th, 2006 12:14 PM |
Setting focus | dalaw | General Discussion | 4 | February 7th, 2006 02:04 PM |
Focus return to textbox on main form after opening popup | Steven | Using Forms | 1 | August 10th, 2005 08:36 PM |
Setting focus to a subform on a Tab Control | Jennifer Eckel-Naborowski via AccessMonster.com | Using Forms | 6 | March 8th, 2005 03:28 PM |
Setting Default Position of Scroll Bar | Gabe | Using Forms | 0 | August 5th, 2004 11:17 PM |