title: MS Access 2007: Is it possible to get (using VBA or something similar) the selected row in open table or from open query results?
body: <p>the title to this question says it all, I am looking for a way to achieve this. Is it possible?</p>
  
  <p>Also, if this wouldn't be achievable, are there maybe any other ways in which I can pass the user selected ID from a table / query to a form (i.e. opening the form is not a problem, using the hyperlink field, passing the value of what was clicked is the tricky part).</p>
  
  <p>Thank you.</p>