Using text in an excel cell drop down list to open Microsoft access to a specific record using VB.

[DocAElstein]

Thanks for lettings us know and sharing your answer.
I don't know anything about Access, but getting the quotations and apostrophes right in VBA coding generally is something I frequently spend a lot of my life doing, unfortunately ....
Alan