G
Gary Dolliver
Hi all,
I have two combo boxes that are unbound. They are initially populated by an
onLoad event which works correctly. The combo boxes are related to two
tables, Item_Type and Item_Style. In the table Item_Style, I will have
multiple entries for Item_Type sometimes even with the same description, for
example:
[Item_Type]
Item_Type_ID Item_Type Description
1 Storybook
2 Photobook
[Item_Style]
Item_Style_ID Item_Style_Description Item_Type_ID
1 Red 1
2 Blue 1
3 Green 1
4 Black 1
5 Red 2
6 Blue 2
7 Green 2
The problem I am having is that when it initially loads, it will show the
correct values based on DLookups performed on load. However, when I try to
change the Item_Style, it will select one from the wrong Item_Type. (If I
have an Item_Type_ID of 1 and I select Red, it gives me Item_Style_ID of 5,
when it should be 1). My filtering works in which it only shows the
Item_Style_Description and Item_Style_ID that relate to the Item_Type, but
when a selection is made, it does not select the Item_Style for the correct
Item_Type.
Hope this makes sense, any help would be appreciated.
-gary
I have two combo boxes that are unbound. They are initially populated by an
onLoad event which works correctly. The combo boxes are related to two
tables, Item_Type and Item_Style. In the table Item_Style, I will have
multiple entries for Item_Type sometimes even with the same description, for
example:
[Item_Type]
Item_Type_ID Item_Type Description
1 Storybook
2 Photobook
[Item_Style]
Item_Style_ID Item_Style_Description Item_Type_ID
1 Red 1
2 Blue 1
3 Green 1
4 Black 1
5 Red 2
6 Blue 2
7 Green 2
The problem I am having is that when it initially loads, it will show the
correct values based on DLookups performed on load. However, when I try to
change the Item_Style, it will select one from the wrong Item_Type. (If I
have an Item_Type_ID of 1 and I select Red, it gives me Item_Style_ID of 5,
when it should be 1). My filtering works in which it only shows the
Item_Style_Description and Item_Style_ID that relate to the Item_Type, but
when a selection is made, it does not select the Item_Style for the correct
Item_Type.
Hope this makes sense, any help would be appreciated.
-gary