Next Date Default

[Guest]

I have a table that lists events and the dates associated with them. On my
switchboard, I want a drop down box that defaults to the next event name
based on the associated date. Is that possible?

 

[Guest]

Something like this as the Row Source for the Combo box should show the next
event at the top.

SELECT tblEvents.Event, tblEvents.EventDate
FROM tblEvents
WHERE tblEvents.EventDate >= Date()
ORDER BY tblEvents.EventDate;