Set Focus - Microsoft Access Forum - Computer Learning Zone


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Set Focus

Michelle Seidelin

5 years ago

Hello Richard

Just can't remember which lesson or tech help video you showed how to set focus to a certain field e.g. first name now that I have the DSUM working to get the next number instead of having the auto number is my customer number which you course which was caught way back at the beginning on level I now that I am trying to make it better I need to know which lesson to give the focus to the first name field is there is another field before that I don't want to set the tab to this one as I need to be able to use the first field when I need to

Thank you again for your great support is gratefully appreciated

	Richard Rost @Reply 5 years ago
Use either Control.SetFocus or DoCmd.GoToControl SetFocus / GoToControl

Michelle Seidelin OP @Reply

5 years ago

Hello Richard I notice the set focus shortcut you have given me is to develop the 13 I am only up to develop a six as far as purchasing and only up to expert 12 as far as building can you suggest an easier way of setting the focus I tried to fiddle around with the tab order and the tab order seem to change okay I wanted to start on first name but when you go to a new record using a new record button which is the way it set up at the moment on the customer table/customer form there is no sign of the flashing cursor until I push the tab key any suggestions thanks for all your help

Michelle

	Richard Rost @Reply 5 years ago
There's really no easier way to do it. It's one line of code that you need to add to your button. `DoCmd.GoToRecord ,, acNewRec ' this will move to a new record DoCmd.GoToControl "FirstName" ' this will move to the First Name field` I can't think of an easier way to do it.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View