Change Value on Combo Box upon event

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

combo box value list of fiscal quarter Select Query 1
OnChange combo box 2
Need combo box to refresh when moving to new record 2017 1
Access 2 Digit year in Access Text Box 3
Change public function value 1
Change the Record Source of the form based on the combo box select 4
Combo Box Dropdown 4
Combo Box Wizard 1

Top