Well . . . Neither of your Forms has a field called 'Agent'.
Change that line of code to this:
Code:
strCriteria = "[Agent Name] = '" & Me.[Agent Name] & "' "
Since both your forms have fields named 'Agent Name' - this should work.
I have it working in the copy that I pulled onto my pc.
When I run the Canada Tracker Form and go to a record that has a date of 9/19/2011 - and click Search - the DetailForm opens and it shows records for the Agent that is on the Canada Tracker Form.
Also - if you MUST have the DetailForm open in an Excel-like view [DatasheetView] - then try this:
Code:
DoCmd.OpenForm "DetailForm", acFormDS, , strCriteria
the 'acFormDS' - forces the data to be displayed in Datasheet View.
Let me know if it works for you now.