Save button on Form

[arnelgp]

It is best to build a cascading combo. So only those avaiable will be shown.

 

[pasin]

You mean it is showing empty values because it is also listing records with empty values from the result in the subform? The years combo will always show 4 values in any situations. Its values will not depend on other combo values

It is best to build a cascading combo. So only those avaiable will be shown.

 

[arnelgp]

You chk first if there is a value in the subform that yoi are looking.