Values in form

[Kelsey]

I have the following code in my vendor combo box control on main form...

Private Sub Vendor_AfterUpdate()
Me!frmPurchaseOrderSub.Form!InventoryID.Requery
End Sub

Then in InventoryID I have the recordsource..
InventoryID, Inventory Item, and VendorID with criteria
[Forms]![frmPurchaseOrder]![Vendor]

It all works great when I select a Vendor it limits the InventoryID's to items only from that vendor. When I add records and proceed to the next, it saves the values in my tables but if I scroll to the previous records, the InventoryID is blank.


Any thoughts?

[RuralGuy]

Is InventoryID a ComboBox control on the SubForm? Does it have a ControlSource?

[Kelsey]

Yes InventoryID is a ComboBox in SubForm. The ControlSource is InventoryID.

[RuralGuy]

The cbo is blank because nothing in the RowSource of the cbo matches the current value of the ControlSource.