I have two comboboxes on a form (cbo_Start and cbo_End).
The record source of both is currently set to the same query: qry_StartEnd.
qry_StartEnd contains the following fields:
StartEnd_Name (Text, example - "08/2010")
StartEnd_Start (Date, example - "08/01/2010")
StartEnd_End (Date, example - "08/31/2010")
The bound column of each combo box is "StartEnd_Name".
I would like to be able to change the values of the second combo box (cbo_End) based on the value selected in the first combo box (cbo_Start) so that the user is forced to select an end month greater than the value selected in the first combo box.
Any ideas?
Thanks!
The record source of both is currently set to the same query: qry_StartEnd.
qry_StartEnd contains the following fields:
StartEnd_Name (Text, example - "08/2010")
StartEnd_Start (Date, example - "08/01/2010")
StartEnd_End (Date, example - "08/31/2010")
The bound column of each combo box is "StartEnd_Name".
I would like to be able to change the values of the second combo box (cbo_End) based on the value selected in the first combo box (cbo_Start) so that the user is forced to select an end month greater than the value selected in the first combo box.
Any ideas?
Thanks!