It is as follows originally:
I am trying to modify a existing form so that if I enter a
classification of
an activity from one drop down box and I then select the activity
dropdown
box that it will display only those activities found under that
classification. This information is being enter into a Activity table
but
the information for some of the fields on the form is being pulled from
lookup tables.
It was suggested to me to do this by one of my former instructors when I tool certification classes.
1. Create a form with the "Classification" combo box. (Don't do the
"Activity" combo box yet)
2. Create a query that lists the Classifications and Activities, and
for
criteria under the Classification field, make a reference to the
"Classification" combo box that you created in step 1. (ex.
Forms![NameOfForm]![ClassificationComboBox] )
3. Now create the "Activity" combo box using the wizard and make the
query
you created in step 2 the Record Source.
4. If it doesn't work at this point, then open the properties of the
"Classification" combo box, and in the After Update property, create
and
event procedure that says:
ActivityComboBox.Requery
....where "ActivityComboBox" is whatever you named the Activity combo
box on
the form.
The problem is that when I go to select the activity after selecting the class is popping up a parameter box with the criteria info that I specify the along the top. If enter a existing class then the activites for that class will appear. Therotically I should be able to select the class and the activities that belong to that class appear when I click the activity combo box without the parameter box appearing.. I have tried contacting my former instructor but he is doesn't have the time right now to look at my issue. If you can't help or pretty busy maybe you know someone who might have the answer to my problem. Thanks.
I am trying to modify a existing form so that if I enter a
classification of
an activity from one drop down box and I then select the activity
dropdown
box that it will display only those activities found under that
classification. This information is being enter into a Activity table
but
the information for some of the fields on the form is being pulled from
lookup tables.
It was suggested to me to do this by one of my former instructors when I tool certification classes.
1. Create a form with the "Classification" combo box. (Don't do the
"Activity" combo box yet)
2. Create a query that lists the Classifications and Activities, and
for
criteria under the Classification field, make a reference to the
"Classification" combo box that you created in step 1. (ex.
Forms![NameOfForm]![ClassificationComboBox] )
3. Now create the "Activity" combo box using the wizard and make the
query
you created in step 2 the Record Source.
4. If it doesn't work at this point, then open the properties of the
"Classification" combo box, and in the After Update property, create
and
event procedure that says:
ActivityComboBox.Requery
....where "ActivityComboBox" is whatever you named the Activity combo
box on
the form.
The problem is that when I go to select the activity after selecting the class is popping up a parameter box with the criteria info that I specify the along the top. If enter a existing class then the activites for that class will appear. Therotically I should be able to select the class and the activities that belong to that class appear when I click the activity combo box without the parameter box appearing.. I have tried contacting my former instructor but he is doesn't have the time right now to look at my issue. If you can't help or pretty busy maybe you know someone who might have the answer to my problem. Thanks.
