enter data in a combo box based on value from another combo box
I am not familiar enough with access to handle this on my own, any help is
greatly appreciated.
I have a problem in trying to populate a combo box based on the value from
another combo box. I cannot use the default value property because the
entire record is blank until I enter data into the first combo box. The
person using the form must have the ability to overide the automated entry
and select from a dropdown list. This is why I am using a second combo box.
The value needed for the second combo box is obtained from the same table as
the first combo box. Method: From the first combo box, I select the
guidelist value (field name: Guidelist) that I want. What I need done is a
lookup where the second combo box titled: ActivityCode is populated with the
ActivityCode value that corrosponds to the Guidelist value selected. I
assume that this is done using the AfterUpdate event.
Table: Guidelist
Field: Guidelist
Field: ActivityCode
Form: frmLocalData
SubForm: subfrmDailyInput
combo box: combo14 = [guidelist]
combo box: combo20 = [ActivityCode]
Thanks Again
Roger
