I NEED HELP!!!

[Guest]

I need the form to react in this manner.

First: I have 3 tables: Region, City, Event.
There are 11 regions, and multiple cities for each region. In the form, I
need the user to pick a region then have a set of corresponding sities for
that region and only that region.

Once the user has chosen a region i.e. (Bay Area Region) the user then
chooses from the following cities. (Alameda, Contra Costa, Marin, San Fran,
San Mateo, and Santa Cruz). There are more cities but because the user chose
Bay Area Region, only previous citie show up in the form.

Next: The user needs to fill out the event information (Which is unique
data). I have made sure that no information is duplicated and the tables are
as lean as posibble. I can make the tables collect the data the way I want
them to with sub tables, but when I start building my form I just can't make
the information appear the way I need it to.

Tables are as follows:
tables are linked ((Region 1-oo City)(City 1-oo event))
___________________
Campaign Region Table
RegionID
Campaign Region (listed regions within a record)
____________________
City table
CityID
City (listed cities within a record)
Campaign Region (used lookup wizard to link)
___________________
Event table
EventID
City (used lookup wizard to link)
Number of events (used lookup wizard and created own list. 1st, 2nd...)
Month (used lookup wizard and created own list. Jan., Feb...)
Name of event
Event sponsor
Attendance
Individuals reached

Form: ( ) = Data input area as it appears in form


(Region)
User choose from drop down box

(cooresponding city to region)
User choose from drop down box

(number of event)
User choose from drop down box

(month)
User choose from drop down box

(name of event)
User enter

(event sponsor)
User enter

(attendance i.e. 100)
User enter

(individuals rached i.e. 50)
User enter


callculator (developped in a query, indv. reached x 3) nothing entered.

how do I make this work?????????????????????????????

 

[Rick Brandt]

I need the form to react in this manner.

First: I have 3 tables: Region, City, Event.
There are 11 regions, and multiple cities for each region. In the
form, I need the user to pick a region then have a set of
corresponding sities for that region and only that region.

Once the user has chosen a region i.e. (Bay Area Region) the user then
chooses from the following cities. (Alameda, Contra Costa, Marin, San
Fran, San Mateo, and Santa Cruz). There are more cities but because
the user chose Bay Area Region, only previous citie show up in the
form. [snip]

Check the help topic "Cascading ComboBoxes". It describes exactly how to do
this. Essentially the query used for the RowSource of one ComboBox uses the
value in another ComboBox as filter criteria.

EX:
SELECT CityName
FROM City
WHERE Region = Forms!FormName!RegionComboBoxName

In the AfterUpdate event of the Region ComboBox you need to issue a Requery
on the City ComboBox.

 

[Rick B]

When you asked this same question on July 20th, you were given a very
detailed response. Did this response not meet your needs for some reason?