dynamic rowsource on continuous subform

[Funger]

I have a form with a continuous subform on it. This subform contains the subject areas of a subject. On this continuous subform, is a dropdown which holds the grade values that are available for the current subject area. Each subject are can have its own set of grade values.

The problem is though that when I change the rowsource of the dropdown, the values that are not in the current rowsource disappear.

I read somewhere to change the rowsource of this dropdown on the Enter event to the limited set, and then change it back to the complete set on the Exit event.

This doesn't seem to work, and all kinds of chaos ensues.

Can anyone please tell me how to get this to work? Of course time is something that I am out of, as report cards are due at the end of next week, and this software is being used by multiple clients. Sigh.

Thanks for any help in advance.

-Funger

 

[Funger]

Sigh. Thanks for replying at least. I can't believe that this functionality was completley overlooked in Access... Then again, knowing about some of the other shortcomings in Access, maybe it isn't so hard after all.

-Funger