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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Controling Navigation in a Form

Status
Not open for further replies.

mje397

Programmer
Nov 3, 2004
17
US
Is it possible to control the navigation between the various entities in a form .. for eg I have

Combobox 1
Combobox 2
Combobox 3

If value of "combobox 1" is say 2 then go to "combobox 2" or else go to combobox 3..

Thnx in advance

 
Use the combo's AfterUpdate event to set Focus; here's some pseudo-code (you can check Access VBA help for exact syntax if necessary):
select case combobox1
case 2
combobox2.focus
case 3
combobox3.focus
end select

Hope this helps.

[pc2]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top