This is for a hobby online simulation

I have a form table - top row I would select Mission (the values are
derived from a recordset for tblMissions).

next 8 rows have the following.

Mission | Callsign | Kills | Death | Bombing |

This form is for whoever hosts a flight - they then goto the website and
enter the scores for each pilot. I would like the Mission column to be
hidden fields - pulling the value selected above in the first row. Callsign
is then pulled from values of a separate recordset for tblPilots - and the
rest is entered normally.

Since we can have anywhere from 1 to 8 max pilots - need the 8 rows.

This then populates however many records into tblScores for later Queries.

Problem I am running into - Is I start the form - the default value of
mission is on the first alphabetical one - I change it none of the 8 data
rows change - they all stay with whatever the first selection was.

Any ideas how to make each of the 8 mission rows requery after a selection
is made?