thank you for sharing your Autofill subform sample.  I've learned from it and can reproduce it for my application - however, I have a question.

If the user selects Vegetables, the sub-form is loaded with the single value of bean.

If the user changes the selection to Fruit, the child form RETAINS the value of the Vegetable, and ALSO adds the fruits.

That might be nifty in some instances, but I would like the child values to go back to blank if the user changes from Vegetable to Fruit

Can you (or anyone else) explain how to do that?

Thank you!