Refreshing?? Combo Boxes

Seems to be the week of asking for assistance!!!

I had a thread started here which after poppa smurf sorted me out and got me back to basics it is working great!!!!

http://www.access-programmers.co.uk/forums/showthread.php?t=172219

WRT to the same set of combos...What I would like to do is is have the combos "Refresh" in a cascading manner also.

I am not sure what to search on...I have tried requery, refresh, loop and have not found what I am looking for, let alone being able to apply it yet.

In my sample there are 6 cascading boxes to choose. What I would like to do is if Combobox #3 content is changed it "refreshes" the dependent (4, 5, and 6) boxes to blank.

If Box #4 was changed, then boxes 5 and 6 would be refreshed to blank. If box #1 was changed then all would be refreshed to blank, etc.

What should I be searching for to try to do this action?
Is the action I want "attached" to the combo boxes or the form itself?

In addition, it would also be nice not to have the values show if the previous box has nothing in it; like start the at combobox 4. Not sure if the answer to the above solves this also.

Thanks for your assistance.

Cheers

Navyguy

Put this in the After Update for your CBO_ProductCategory after your coding for the recordsource of CBO_ProductDescription
This coding below will set the display of ALL combo boxes after CBO_ProductCategory to NULL

Me!CBO_ProductDescription = Null
Me!CBO_ProductManufacturer = Null
Me!CBO_ProductNumber = Null
Me!CBO_ProductUnitOfIssue = Null
Me!CBO_ProductPrice = Null

Check that your recordsource for the next combo box is working as you make the changes for each combo box.

You will need to modify the code as you use it for each combo box.

Well poppa smurf...this is twice you have helped me out with very easy solutions. I seem to be trying to over complicate things.

Thank you for your assistance.

Cheer