Hi ChrisMore
To limit the combo to list only the shipment number associated with each order, you need to but a "criteria" in the query of the combo box, in the form design view, Property Sheet, Row Source of the combo box.
- Remove the "Shipments" table "or whatever it's" from the Row Source.
-...