Form not opening with correct record

[marnieg]

I have a multi-record browse form. On each record displayed I have a button that selects the record to open to more detail using code

strLinkCriteria = Me.ID
DoCmd.OpenForm "Contacts", , , strLinkCriteria


Where the ID is the key to the table. My detail form "contacts" always comes open with the first record in the table, NOT the value I am passing to it.

the Contacts form is pretty straight forward with properties of the form

Record Source is Query of all fields in this table
Fetch Defaults Yes
Filter on Load No
Data Entry No
All Allows set to yes

What am I missing?

 

[pbaldy]

Wrong syntax for the where condition:

http://www.baldyweb.com/wherecondition.htm

 

[marnieg]

Thanks for the code examples. That worked!

 

[pbaldy]

Happy to help!