Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Select 1st item in list on form open
- Thread starter knighty03
- Start date
LeanneGodney
Technical User
Hi,
The easiest way to do all of that is to change the tab order in the form. In design view, go to View --> Tab Order, and then grab the field you want and drag it to the top of the list. That usually makes that control the first thing selected when you open a form.
Secondly, to make it select one of the values, you go to the properties of that drop down box and give it a Default value. Simply type the value you want it to select.
Hope that helps. It can also be done in VBA. Let me know if you want to know how to do that (reply to this post).
Leanne
The easiest way to do all of that is to change the tab order in the form. In design view, go to View --> Tab Order, and then grab the field you want and drag it to the top of the list. That usually makes that control the first thing selected when you open a form.
Secondly, to make it select one of the values, you go to the properties of that drop down box and give it a Default value. Simply type the value you want it to select.
Hope that helps. It can also be done in VBA. Let me know if you want to know how to do that (reply to this post).
Leanne
- Status
Similar threads
- Locked
- Helpful tip
- Locked
- Question
- Locked
- Question
- Locked
- Question
