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.