Access 2010 error

[mkoecher]

When opening a record in the library template in Access 2010 I get the error The specified field [ID] could refer to more than one table listed in the FROM claus of your SQL statement. When I click OK, it looks like a macro error. The macro name is Asset List : Item : OnDblClick : Embedded Macro, Action Name is OpenForm, the arguments are Asset Details, Form, , [ID]=577, , Dialog. It says error # 2950. How do I fix it?

[pbaldy]

What is the record source of the Asset Details form? I'm guessing it's a query with 2 fields named ID. If so you'll need to specify which one you want.