Problem Catching Event for Subform with No Records

[Guest]

I want to control the appearance of a subform based on a field value on the
main form. I'm using the Current event on the subform to change background
color, etc, and this works fine. However, if the subform has no records for
the student in question, there is no Current event (apparently), and I can't
control the appearance.

Any ideas? I've tried other subform events and can't seem to catch anything.
Maybe there's a better approach?

Thanks,

Sean

 

[tina]

if the appearance of the subform is based on a value from the main form,
then the subform's appearance should only change when the main form value
changes, correct? how about putting the formatting-changes code in the
*main* form's Current event, and if necessary, in the main form control's
AfterUpdate event also.

hth

 

[Guest]

Tina,

Thanks - that makes sense - don't know why I didn't think of it. I'll try it
today, but I'm sure it will work.

Sean

 

[tina]

you're welcome

Tina,

Thanks - that makes sense - don't know why I didn't think of it. I'll try it
today, but I'm sure it will work.

Sean