Cascading combo boxes

[SunTop]

Hello everyone


I have a form in my database that is supposed to allow the users to alter the fields of a single record of an underlying table. In this form I have two cascading Combo boxes, where the data on the second combo box depends on the data in the first combo box. When the user changes the data in the first combo box, the after update event runs a Requery macro to fetch the new row source values for the second combo box. What happens is that some users change the data in the first combo box and ignores the data in the second combo box, which leaves an unmatched set of data in the underlying table. How to force the user to change the data in the second combo box if he changes the data in the first combo box. I tried setting the validation rule to “is not null”, but that did not work because this is not a new record and there is data in the field.

[CJ_London]

in the same event where you run the code to modify the 2nd combo rowsource, add another line of code to set the 2nd combo value to null.(i.e. me.combo2=Null)

To flag this to the user you can use the 2nd combo format property to show a message when the value is null

based on the underlying 2nd combo bound column data type

for text it would be

@;[Red]"This field must be completed"

and for numbers

;;;[Red]"This field must be completed"

[SunTop]

Thanks Ajax for your reply,

It worked perfectly.