In my Header I have some selection criteria when the user clicks on the Boat Combo box it drives the Parts combo box. These are loaded using Rowsource Query in the properties and the row source set to Table/Query
The criteria than fills the Combo boxes and text boxes in the detail section. which in the properties section they have a control source a query in the Row Source and Row Source Type set Table/Query.
(PS I didn't build this just inherited it)
What I would like to do so it's not confusing to the eyes is blank out the data in the Details section every time I select a new boat.