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...
Type: Posts; User: cyburner
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 ...