title: use report field to open form at current record
body: <p>I had a wander around in the forum but can't find what I am looking for. It might not even be possible but as the command controls are available I suspect it will be. </p>
  
  <p>I have a report which shows a series of records based on a query. The report has a field called "project number" which is the record number from the projects file. The report shows multiple records. Is it possible to set a control on the report either in layout or ideally print preview so that the user can click on the project number on the report and it opens the projects form at the record with the same project number. I have seen a few bits of code on other sites but each time the coder has commented that it did not work? </p>
  
  <p>Is it possible? </p>