Combo box value not updated

[asu81]

Hi!
I've got a form with combo boxes and an OK button. When OK is pressed, an report is opened. The report is filtered from the chosen value in the combo box.

My problem is that if I choose a value and then change my mind and choose another in the same box, the report still shows data filtered on the value that was chosen first.

How do I correct this?
Thanks!

 

[John Big Booty]

What is the code you have behind the button?

 

[John Big Booty]

...is the combo bound or unbound?

 

[asu81]

Thanks for your reply!

Actually I remembered incorrectly regarding the problem. Sorry about that.

I have several combo boxes for data filter, two of which are related. In the first one you pick (1) object type, and in the next you pick (2) sub type. Depending on what you select in (1) the values you can choose from in (2) changes.

My problem is that if you select a value in (1), then click (2), then change your mind and pick another category in (1), the original categories are still displayed in (2). I don't actually have to select anything in (2) the first time for this problem to arise. It's enough that I just look at the values to choose from in (2).

...is the combo bound or unbound?

My combo boxes are unbound. I have selected row sources, but not control sources.

Should I?

Whats the difference?

Sorry for the stupid questions. I'm a beginner

 

[John Big Booty]

OK so you've got a cascading Combo Box set.

In the On Change event of your first Combo you should have some Code along the lines of;

Me.YourSecondComboName.Requery

 

[asu81]

You're my savior, thanks!