I have a form in continuous forms view. The forms record source is a query. Also on the form is an unbound field. When I enter a number in that field, all of the records get filled in with that number instead of just the record I am working on.
If the query is the problem and I can't figure out why, here is the SQL:
SELECT tblProducts.LocationID, tblProducts.ProdRef, Sum([IncomingQty]-[SoldQty]) AS Balance, tblInventoryDetails.ProductID, tblLocations.LocationDesc
FROM (tblProducts INNER JOIN tblInventoryDetails ON tblProducts.ProductID = tblInventoryDetails.ProductID) INNER JOIN tblLocations ON tblProducts.LocationID = tblLocations.LocationID
GROUP BY tblProducts.LocationID, tblProducts.ProdRef, tblInventoryDetails.ProductID, tblLocations.LocationDesc
HAVING (((tblLocations.LocationDesc) Like "*" & [Forms]![frmSelectLocationForReconcileInventory]![txtLocationName] & "*"))
ORDER BY tblProducts.ProdRef;