Re: combo box will not update

[alicejwz]

Re: combo box will not update

Hi everyone,

I need some help in combo boxes. I have two combo boxes on a form. The first combo box allow user to select a customer and the second combo box pops all the part numbers for that customer for the user to choose. The problem I am having when the user reselect the customer combo box the second combox box doesn't display the 2nd customer's part number, it still show the previous part number. I tried requery both combo boxes and it still doesn't work. Can anyone see why?
Your help is appreciated.

This rowsource properties for
customer combo box:
SELECT [DeflashData].[customername] FROM DeflashData GROUP BY [DeflashData].[customername];

parts combo box:
SELECT [DeflashData].[partnum] FROM DeflashData
GROUP BY [DeflashData].[partnum], [DeflashData].[customername]
HAVING (((DeflashData.customername)=[forms]![Deflash Data]![customername]));

 

[maxmangion]

check the FAQ section of this Forum, there is a good sample how to work with Cascading Combo Boxes.