Pick a salesman to see the details of one of their sales:

Often when you're asking a user to fill out a form, some of their options will change based on other things they're inputting. This sample takes the input from the first select box and uses it to query a database to fill in the second.

Note: There is no real sales data (for these fictitious salesmen) beyond the stuff I added for the second select box used in this sample!

This is a sample of building the form... not building a report. I've left out the querying that this form would probably do if it was being used in the real world. As a result, selecting something from the second select box and re-submitting the form doesn't do anything unless you've changed your selection from the first box.

It's pretty straight forward so that's about all I'll say. As always you'll find some comments in the code so if you get lost give them a read. You can download a copy of the sample database (Access 2000) if you want to play with the script on your own machine.