J
JD McLeod
I have a form that uses cascading combo boxes. I have two combo boxes on a
form and I have figured out how to get the second combo box to display
choices based on the value selected in the first combo box. My problem is
that the when an item is selected in the second combo box, it updates all
other records in the form for that choice. Also, the selection is not being
written to the underlying table. Here is what I have:
Table Design:
A table with fields Comments, Category & Subcategory. Category in the table
is a lookup field based on a separate table with categories listed in it. So
the combo box on the form is an easy one to create.
The subcategory field I just left as a text box in my table and created an
unbound combo box with the record source equal to a query.
I can get the combo boxes to perform on the form, I just can’t prevent them
form overwriting other records within the form and I can’t get them to write
the information to the database table. Any help would be appreciated.
Thanks.
form and I have figured out how to get the second combo box to display
choices based on the value selected in the first combo box. My problem is
that the when an item is selected in the second combo box, it updates all
other records in the form for that choice. Also, the selection is not being
written to the underlying table. Here is what I have:
Table Design:
A table with fields Comments, Category & Subcategory. Category in the table
is a lookup field based on a separate table with categories listed in it. So
the combo box on the form is an easy one to create.
The subcategory field I just left as a text box in my table and created an
unbound combo box with the record source equal to a query.
I can get the combo boxes to perform on the form, I just can’t prevent them
form overwriting other records within the form and I can’t get them to write
the information to the database table. Any help would be appreciated.
Thanks.