I just realized I haven't covered this yet in any of my Access 2010 Beginner classes. I'll have to make sure to get to it in Access 8 this week. In the mean time, here's a free Tip video with the basics:

Tab Order in Access 2010

Enjoy!

Capped Values Upload Images   Link  Terry Taylor  9 years ago Great stuff.  Do you have any lessons that demonstrate capped values? Commission = 67% until a capped $ amount is reached then commission is 100%.  Resets every year Reply from Richard Rost: Read More... I haven't covered that exactly, but you can do this using two other techniques I've covered. You'd need a DSUM function to count up commissions between two dates, then an IIF function to decide which commission rate to use. Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.