How can I choose which Clients to run a report on?

[Guest]

Hopefully I can explain this well enough. I have a very large linked table
that holds all of my information. This includes Client Name, Farm Name, and
Field Name (what clients call the field within the farm, such as Home Farm,
North Field). It also holds fertility, soil types, and crop yield as part of
the table. This table is comprised of multiple clients.

This structure could be compared to a table of info on the Countries in the
world...United States being "Client", State being "Farm", and then the city
within the state being "Field".

I have a base set of reports that I have built, which as of right now
reports on the entire table.

Is there a way that I could build a form(?) that allows me to: First, pick
the client I want to report on, then pick which farm of his, and then pick
the field, and then finally which report? So I would pick the client out of a
list, then it would only show me his farm names (since multiple clients could
have the same farm name, such as "Home Farm") that I could pick from, and
then it would only show the field names that belong to that farm (auto
update?).

I would like to be able to choose between allowing the entire table in the
report, narrowing it down to one field, or ultimately, being able to choose
multiple clients on one report (say John, Bill, Frank) but not the other 30.

Am I making any sense?!? Thanks again for any help. I appreciate it!
Bryan

 

[kingston via AccessMonster.com]

Look up cascading combobox.

Basically, you use the AfterUpdate event of the first combobox to change the
RowSource property of the second combobox. So for example, after a selection
was made in ComboBox1, you'd set:

Me.ComboBox2.RowSource = "SELECT Field2 FROM Table WHERE Field1='" & Me.
ComboBox1 & "'"

Then your report would be based on a query (instead of the table) that uses
Forms!FormName!ComboBox1, Forms!FormName!ComboBox2, ... as parameters in the
criteria section.