title: Events in MS Access 2007
body: <p>I just migrated a database <a href="http://en.wikipedia.org/wiki/Microsoft_Access" rel="nofollow noreferrer">MS Access</a> 2003 to MS Access 2007. But I have some problems with the events. 
  When I opened the database (MS Access 2003) start form, I usually can click on the form and if I do double click on it, it will lead me to another form. </p>
  
  <p>Now after migrating to MS Access 2007, when I opened my database start form (MS Access 2007) and double clicked on it, I got this box : "Enter Parameter Value".
  And if I just click ok, I'll get an error: "The expression On Dbl Click you entered as the event property setting produced the following error: ODBC- call failed"</p>
  
  <p>I tried to make an event in the "On Dbl Click" Property to open the another form, but it seems it doesn't work. Do you have any idea where should I look why I'm getting this error?</p>
  
  <p>The screenshots for the error message that I'm getting:</p>
  
  <p><a href="http://picasaweb.google.com/tintincutes/UnbenanntesAlbum#5415010078716383954" rel="nofollow noreferrer">http://picasaweb.google.com/tintincutes/UnbenanntesAlbum#5415010078716383954</a>
  <a href="http://picasaweb.google.com/tintincutes/UnbenanntesAlbum#5415009629637226818" rel="nofollow noreferrer">http://picasaweb.google.com/tintincutes/UnbenanntesAlbum#5415009629637226818</a></p>
  
  <p>Additional question:</p>
  
  <p>I'm also getting an error, <code>ODBC - call failed</code>, if I enter a parameter.
  Did I make any mistakes here?</p>
  
  <hr>
  
  <p>Additional:</p>
  
  <p>I checked the form where I'm having a problem and under "Data" I found under "Order by" the name "Revision.HUhrID". I deleted it and it worked. But when I checked the database access in Access 2003 it contained this "Revision.HUhrID". 
  Do you think deleting this is a good idea? 
  Here is the screenshot I made:
  <a href="http://picasaweb.google.com/tintincutes/UnbenanntesAlbum#5415067821432425986" rel="nofollow noreferrer">http://picasaweb.google.com/tintincutes/UnbenanntesAlbum#5415067821432425986</a></p>