I have a form opening in datasheet view mode. When it opens it shows all of the records even though if I run the recordsource query it only shows those records selected via...
Like "*" & [Forms]![frmSelectLocationForReconcileInventory]![cboLocation] & "*"
in the RecordID field criteria.
The query is fine. It only shows the records I would expect to see.
The report isn't fine. It's showing all of the records.