MBurns,
Use a key unique value on the open form to filter out all records,
but the one you want. Your form table should have some unique key
field, like a CustID, or EmpID, orSerNo.
Since you provided no object names...
If we had a CustID, then the CustID field in our report query should
have
a criteria of
= Forms!frmYourFormName!CustID
--
hth
Al Campagna
Microsoft Access MVP http://home.comcast.net/~cccsolutions/index.html
"Find a job that you love... and you'll never work a day in your life."