Displaying subform field data in main form

[Elaine]

I have a form called frmEvent and a subform called frmEventRaces

In frmEventRaces I have 6 fields labeled Race1, Race2 etc to Race6 and
another yes/no six fields labeled complete.

In frmEvent, I have a textbox called CurrentRace where I would like to
display the data from the current race. (CurrentRace is a display text field
and is not a field from a table.) The current race would be the next item
that does not have check mark in the Complete field. For example if
Complete5, and Complete6 do not have checkmarks, I would like Race5 data to
be displayed in the CurrentRace field of frmEvent.

When Race5 is complete, I would like to have the data from Race6 display.
When all races are complete, I would like the word "Completed Event" to be
displayed.

This seems hopelessly convoluted, but I hope that there is a somewhat easy
answer for this query.

Thanks for your help.

--Elaine