I took the "Error Handler" out, and when the person clicks on the field, it stops the macro and highlights in yellow this portion: "DoCmd.OpenReport "Qualification Document", acViewReport, , _"
With the error handler, when the person clicks on the field, nothing opens and it goes directly to...