Change Value on Combo Box upon event

  • Thread starter Thread starter Angel_G
  • Start date Start date
A

Angel_G

Is there a way that I can change the value on a Combo Box to the last record
in its record source?
I have a combo box that displays Fiscal Years, from 2000 to Current fiscal
year 2007. Users can select any year they wish to pull data from based on
the year selected. However, I want the combo Box to change its value to the
current Fiscal year (which is the last record presented to them when they
select the drop down) based on a specific event.
Anybody have any ideas?
Thanks!
 
Back
Top