displaying a combobox to a record item in the list when initially loaded

[ctolva]

I have a combobox that selects the dates of seminars from a table. This list contains future seminar dates as well as past seminar dates.


I wish to position the data displayed in the combobox to the closest date in the list to today's current date.
The combobox uses a select statement for the Row Source
I believe the VBA code is Me!cmbDate.Selected(x) = true where "X" variable is the row that is closest to today's date.

[ctolva]

Sorry, had a typo should read = true

[ctolva]

I think maybe getting the record position and then refreshing form?