johnnybwis
Technical User
Subform choice is limited by mainform choice with
rowsource
SELECT DISTINCTROW Products.ProductName, Products.ProductID, Products.NumberPerUnit, Products.WeightPerThousand FROM Products WHERE (((Products.CustomerID)=[Forms]![Purchase Orders]![SupplierID])) ORDER BY Products.ProductName;
When the form is opened my Supplier in the main form is OK and the subform combobox choice is OK but then on the next record if the mainform has a different supplier the subform choice is blank until I click on that field which it then appears. Then all the following records will be OK also.
There is a requery on enter
How do I keep all the choices visible when the form is opened.
rowsource
SELECT DISTINCTROW Products.ProductName, Products.ProductID, Products.NumberPerUnit, Products.WeightPerThousand FROM Products WHERE (((Products.CustomerID)=[Forms]![Purchase Orders]![SupplierID])) ORDER BY Products.ProductName;
When the form is opened my Supplier in the main form is OK and the subform combobox choice is OK but then on the next record if the mainform has a different supplier the subform choice is blank until I click on that field which it then appears. Then all the following records will be OK also.
There is a requery on enter
How do I keep all the choices visible when the form is opened.
