Sorry everyone - it looks like that this has been done to death, all except for this question......
I have a combo-box (cb1) from which a user selects a value (row source = a query), When the user make a choice, the 'after update' event runs a macro that performs a 'requery' on another combo-box (cb2) to recalculate its list based on the new value. I then set the 'focus' to cb2, want to clear any previously selected value (which may no longer be available) and make the user reselect. How can I force the user to reselect? cb2 is bound to a column in a table and if I make it not 'required' and then set cb2 to null, even with 'limit to list' set the user is not forced to make a selection. I even tried setting the value to '(reselect)' which is never a valid value but the validation still doesnt occur.
I have a set of cascading combo-boxes so this is quite critical to me!
Really would appreciate some help!
I have a combo-box (cb1) from which a user selects a value (row source = a query), When the user make a choice, the 'after update' event runs a macro that performs a 'requery' on another combo-box (cb2) to recalculate its list based on the new value. I then set the 'focus' to cb2, want to clear any previously selected value (which may no longer be available) and make the user reselect. How can I force the user to reselect? cb2 is bound to a column in a table and if I make it not 'required' and then set cb2 to null, even with 'limit to list' set the user is not forced to make a selection. I even tried setting the value to '(reselect)' which is never a valid value but the validation still doesnt occur.
I have a set of cascading combo-boxes so this is quite critical to me!
Really would appreciate some help!