A
alex
Cascading ComboBox on SubForm
Hello,
Using Access ’03…
I hope this doesn’t confuse too many people (I know I am).
I have a subform (in ds view) on a main form. The subform has about 8
fields, 5 of which are cascading combo boxes.
The records in the subform will never be null, the user is only able
to modify or delete the record.
The combo boxes are all based on 1 table that could be considered a
key for the values contained in all of the 5 combo boxes (there are
over 20k records in that table).
For example the rowsource of each combo box is bound to its respective
field in the table and the other 4 fields are used as criteria.
Something like this:
Like [Forms]![frmMyMainForm]![sfrmMySubform].[form]![FieldID]
What I just described above seems to work fine when the first record
is entered from the main form; i.e., each combo box value is limited
to the value in the other 4 combo boxes!
The problem: when the second and subsequent records are entered, the
values of the combo boxes appear to relate (are based off of) the
first record. I.e., the combo boxes are not being evaluated based on
each individual record, but appear to only relate to the first
record’s value!
If anyone has a suggestion as to what I may be doing wrong, please let
me know.
Thanks,
alex
Hello,
Using Access ’03…
I hope this doesn’t confuse too many people (I know I am).
I have a subform (in ds view) on a main form. The subform has about 8
fields, 5 of which are cascading combo boxes.
The records in the subform will never be null, the user is only able
to modify or delete the record.
The combo boxes are all based on 1 table that could be considered a
key for the values contained in all of the 5 combo boxes (there are
over 20k records in that table).
For example the rowsource of each combo box is bound to its respective
field in the table and the other 4 fields are used as criteria.
Something like this:
Like [Forms]![frmMyMainForm]![sfrmMySubform].[form]![FieldID]
What I just described above seems to work fine when the first record
is entered from the main form; i.e., each combo box value is limited
to the value in the other 4 combo boxes!
The problem: when the second and subsequent records are entered, the
values of the combo boxes appear to relate (are based off of) the
first record. I.e., the combo boxes are not being evaluated based on
each individual record, but appear to only relate to the first
record’s value!
If anyone has a suggestion as to what I may be doing wrong, please let
me know.
Thanks,
alex