subform record selection

olorin

Registered User.
Local time
Today, 18:31
Joined
Jun 9, 2006
Messages
81
Hi people,
I have a form for entering details to generate a shipping note.
On the form is a subform which updates when the user selects the product to be shipped. The subform shows all outstanding purchase orders for the selected product.
Nine times out of ten, the purchase order to be used is the first in the list of the subform. The mainform gets the PO and any bookingIn reference from that record in the subform.
The problem is when someone wants to ship against a different PO from the subform, instead of the first record. It still copies the PO of the first record to the ShipNote, and not the one selected.
Is there a way to make the mainform get the details of the selected record on the subform, and not the first record?

Thanx in advance.
 

Users who are viewing this thread

Back
Top Bottom