I have a form, with a record source with SQL.
In this form I have two subforms, each with a SQL query as the subform record source.
One of the two subforms is used as a reference. For example, the subforms tells me how many tonns of cargo is left on the ship. In the other subform I type in how...