I have a Main Form "frmInvoice" and a subform "subfrmShipments". Linked on InvoiceNumber field. One invoice to many shipments.
Combo Box on subform has rowsouce as SELECT ShipmentID, InvoiceNumber, TrackingNumber FROM tblShipments;
and in after update event
t "[ShipmentID] = " & Me![Combo15]
Me.Bookmark = Me.RecordsetClone.Bookmark
Problem is the Combo Box only updates / finds the records relating to the invoicenumber on the main form. Is there a way to get it to update even if the main form is not currently on the related InvoiceNumber?
Scaled down version of db attached. First frmInvoice record has 3 shipments, if selecting the fourth record in the drop down of the Combo Box the record is not selected.