Search:

I figured out the syntax error. The correct format of the line of code should read:

oApp.DoCmd.OpenForm "Recipes", , , "RecipeName='" & Range("b8") & "'"

The quotations and apostrophes weren't...

Moderator Notice:
Copied by me to here
Re https://excelfox.com/forum/showthread.php/2730-Using-text-in-an-excel-cell-drop-down-list-to-open-Microsoft-access-to-a-specific-record-using-VB
Alan...

Moderator Notice:
Copied by me from here
Re https://excelfox.com/forum/showthread.php/2723-Using-text-in-an-excel-cell-drop-down-list-to-open-Microsoft-access-to-a-specific-record-using-VB ...