Need Main Form Combo Box to Update Records in Subform Field

[dascoli]

I have a database designed to track trips made by my company's vehicles. There is a form (frmTripEntry) that contains a subform (sfrmTripDetails). The main form tracks the trip, the subform tracks each stop made by the vehicle.



Here is what I want to happen:
After updating the Van Number combo box on the main form I want to assign the updated van number to the Van Number field for all records in the subform.

I am sure that some kind of a loop is needed, but I have no experience with loops so I am unsure where to begin.

Main Form Field:
Combo7 - Control: VanNum - Table: tblTrips - Data Type: String

Subform Field:
VanNum - Control: VanNum - Table: tblTripDetails - Data Type: String

Any help is greatly appreciated!

[pbaldy]

For starters, why would vehicle be saved in the details table? It sounds like an attribute of the trip, not of a stop.

[dascoli]

As I was writing my reasoning for doing this I realized that it was pretty stupid and I could accomplish my final goal another way. You can delete this thread. Thanks for taking the time to answer.

[pbaldy]

No problem.