I have a form/subform combo with the following relevant fields:
Form:
Supplier
Subform:
Item - combo box based on supplier
Description - this is just Item.Column(1)
What currently happens is when I re-open the form after making previous entries, Item lists in all records are based off the Supplier chosen in the first record, rather than their respective records. It still displays the correct information in the Item field, but if you go to make an adjustment, you get the wrong list. Also, the description field is blank (once again, only where the supplier of said record differs from the supplier in the first record).
I'm using the following code to update the Item list upon Supplier selection:
Code:
Private Sub Supplier_AfterUpdate()
Forms![RawMaterialReceiving]![RawMaterialReceivingSub].Form![Item].Requery
End Sub
What I want is for each record to have the correct Item list and Description based on respective Supplier selection.
Thanks for any help!