Requery a Combo Box based On Radio Button

[jmarcrum]

Hey everyone!!

I have a form with a year combo box, a month combo box, a Day combo box, and an Option Group with 2 choices (Sunday and Wednesday). If the user selects a year, then selects a month, i have code written that checks to see which option (Sunday or Wednesday) has been chosen, and then the Day combo box populates with all of the Sundays or Wednesdays that are found in that particular month and year. Now...this is working great, however...

If the user initially chooses Sunday and then changes his/her mind and clicks on Wednesday, the Day combo box doesn't reflect the decision. It continues to be populated with all of the Sundays found in the selected month of year. How do I get the Day combo box to re query?

Thanks,

-Joseph

[jmarcrum]

Nevermind, i figured it out!

I just copied the code I had on the after_Update for the Year combo box and put it in for the after_update on the Option Group!

YAY!!

Thanks,

-Joseph