Refreshing parameter default values from a combo box selection

[garybug]

Dear all..

I have a combo box, where the user selects the month - this is then used as a filter parameter in my dataset query. However, I have another parameter, which is set to default value MonthSelected - 1 month. This works fine when the drop down box is used the frist time - but when the user selects another month, the 'default' value in the other parameter box stays the same, even after they click th Refresh logo.

E.g.

User select Sept. 2006, the other box chages to Oct. 2006
User then selects July 2006, the other box REMIANS at Oct. 2006.

What am I doing wrong, or is there a hidden 'After Update' method I need to code??

Ta

Gary

 

[Catadmin]

How are the second parameters values coded? Available and default.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"