Combo Box Trouble

  • Thread starter Thread starter Gary Dolliver
  • Start date Start date
G

Gary Dolliver

Hi all,
I have two unbound combo boxes (c1 and c2) that based on the value of c1,
will determine what shows for c2. By selecting c1, it will correctly limit to
what c2 shows, but when I select the option for c2, it is not choosing the
correct value. The result set for c2 is based off a table, that has the
following format:
ISID ISD ITID
1 red 1
2 blue 1
3 green 1
4 red 2
5 blue 2
6 green 2
c1 will select the ITID, which then limits what I see in c2 to the correct
set (I even brought in the ISID column to make sure the numbers are correct)
- however, when I select and ITID of 1 and then "red", instead of showing 1,
it shows 4 - I have a feeling it is because the field names are the same, but
am unsure how to move forward?

The first combo box (c1) determines the Item_Type_ID (ITID) and the row
source
is: Item_Type (Table) - the numeric value from this combo box then fills into
a text field [ITID] that is then used in the WHERE clause for the second
combo box (I made this so I could make sure it was selecting the correct
value)

The second combo box (c2) determines the Item_Style_ID (ISID) and the row
source
is:
SELECT Item_Style.Item_Style_Description, Item_Style.Item_Style_ID,
Item_Style.Item_Type_ID FROM Item_Style WHERE
(((Item_Style.Item_Type_ID)=forms!RECEIVING_REDO_Check_In!ITID));

I have the second combo box showing both the Item_Style_Description
(Description = Red) and the ISID (ID = 1) and I have another text box that
populates the ISID (into text field [ISID]) from what is selected from the
second combo box. However, in the text field ISID, it shows the value 4 -
which is also Red, however, this is for Item_Type_ID 2 - incorrect. I
already
selected Item_Type_ID 1 from the first combo box, and could see the values
in c2, but for some reason, it is showing the incorrect item_style as an end
result.

Hope that makes sense, please let me know if you need anything else, thanks
again

-gary
 
What method are you using to set the value of the text box that displays
the ISID (i.e. - Column method, DLookup, etc.)?
 
Hi there, thank you for the reply.
I am using a DLookup that is called in an AfterUpdate of the combo box
ISID.Value = DLookup("Item_Style_ID", "Item_Style",
"Item_Style_Description=" & "[ItemStyle].Value")

-gary

Beetle said:
What method are you using to set the value of the text box that displays
the ISID (i.e. - Column method, DLookup, etc.)?
--
_________

Sean Bailey


Gary Dolliver said:
Hi all,
I have two unbound combo boxes (c1 and c2) that based on the value of c1,
will determine what shows for c2. By selecting c1, it will correctly limit to
what c2 shows, but when I select the option for c2, it is not choosing the
correct value. The result set for c2 is based off a table, that has the
following format:
ISID ISD ITID
1 red 1
2 blue 1
3 green 1
4 red 2
5 blue 2
6 green 2
c1 will select the ITID, which then limits what I see in c2 to the correct
set (I even brought in the ISID column to make sure the numbers are correct)
- however, when I select and ITID of 1 and then "red", instead of showing 1,
it shows 4 - I have a feeling it is because the field names are the same, but
am unsure how to move forward?

The first combo box (c1) determines the Item_Type_ID (ITID) and the row
source
is: Item_Type (Table) - the numeric value from this combo box then fills into
a text field [ITID] that is then used in the WHERE clause for the second
combo box (I made this so I could make sure it was selecting the correct
value)

The second combo box (c2) determines the Item_Style_ID (ISID) and the row
source
is:
SELECT Item_Style.Item_Style_Description, Item_Style.Item_Style_ID,
Item_Style.Item_Type_ID FROM Item_Style WHERE
(((Item_Style.Item_Type_ID)=forms!RECEIVING_REDO_Check_In!ITID));

I have the second combo box showing both the Item_Style_Description
(Description = Red) and the ISID (ID = 1) and I have another text box that
populates the ISID (into text field [ISID]) from what is selected from the
second combo box. However, in the text field ISID, it shows the value 4 -
which is also Red, however, this is for Item_Type_ID 2 - incorrect. I
already
selected Item_Type_ID 1 from the first combo box, and could see the values
in c2, but for some reason, it is showing the incorrect item_style as an end
result.

Hope that makes sense, please let me know if you need anything else, thanks
again

-gary
Click to expand...
Click to expand...
 
Back
Top