D
Dean Simpson
I am have huge problems with combo boxes when a form is starting up. The
main problem is when I open a form, the values are not being displayed.
I have 2 combo boxes (Group, Category).
Group is a table with GroupID(Key) and Description
Category is a table with CategoryID(Key),GroupID , Description
Then I have a table (Products ) which has a field CategoryID which links to
the Category Table.
Under relationships they are joined by Group Table to Category Table to
Products Table
I can sync the 2 combos together when the Group changes etc but I cannot get
the combos to display the values when the form opens.
Values are the descriptions in both cbo's
The category combo control source is bound to the CategoryID in the Product
Table
Can anyone help
Thanks in advance
main problem is when I open a form, the values are not being displayed.
I have 2 combo boxes (Group, Category).
Group is a table with GroupID(Key) and Description
Category is a table with CategoryID(Key),GroupID , Description
Then I have a table (Products ) which has a field CategoryID which links to
the Category Table.
Under relationships they are joined by Group Table to Category Table to
Products Table
I can sync the 2 combos together when the Group changes etc but I cannot get
the combos to display the values when the form opens.
Values are the descriptions in both cbo's
The category combo control source is bound to the CategoryID in the Product
Table
Can anyone help
Thanks in advance