Combobox values (1 Viewer)

[weilerdo]

Hi all, I know this is more then likely a simple thing but I cant seem to figure this last little part out.

I have a Form that has 2 combo boxes on it. cbo2 is populated from criteria of cbo1. All of it works fine. I have it set up that when the user opens the form the combos are blank and my subform shows ALL records. (exactly what I want) When they select a value from cbo1 I have it requering the subform ( working correctly ) and when they select cbo2 it requeries and the subform and it works just the way it should. My problem is how do I then alway the user to show all reports in the subform again. Not sure if I need to create a button that will somehow reset the combos to blank for can I add a value to the combos for show all records.

Thanks for any help on this one, I hope I explained it well enough.

Don

 

[pbaldy]

You could do either, but I would probably use the button, since it's easier to click on 1 button than make selections in 2 combos. Really depends on how you want it to work though.