Dear Friends
Merry Christmas and Happy New Year!
I am building a form with subform.
I want to set different default value in the subform. The value will depend on a cell value in the form.
For example:
If the value of "Category" in the form is "1", the default value in the subform would be-
Description Unit Amount
1. Beer Bottle 3
2. PotatoChip Pack 1
If the value of "Category" in the form is "2", the default value in the subform would be-
Description Unit Amount
1. Beer Bottle 5
2. PotatoChip Pack 2
If the value of "Category" in the form is "3", the default value in the subform would be-
Description Unit Amount
1. Beer Bottle 10
2. PotatoChip Pack 5
Hope somebody help me.
Thanks in advanced.
Sai Kyaw Han
Merry Christmas and Happy New Year!
I am building a form with subform.
I want to set different default value in the subform. The value will depend on a cell value in the form.
For example:
If the value of "Category" in the form is "1", the default value in the subform would be-
Description Unit Amount
1. Beer Bottle 3
2. PotatoChip Pack 1
If the value of "Category" in the form is "2", the default value in the subform would be-
Description Unit Amount
1. Beer Bottle 5
2. PotatoChip Pack 2
If the value of "Category" in the form is "3", the default value in the subform would be-
Description Unit Amount
1. Beer Bottle 10
2. PotatoChip Pack 5
Hope somebody help me.
Thanks in advanced.

Sai Kyaw Han