Macro to VBA Conversion Error

[Kutach770]

Hello all. I'm new to this forum but am a self-educated access user from "Google University."

I've run into a problem involving a button on a form that, when clicked, opens another form to a specific record. The macro (which the wizard creates) is fine. But when I convert the macro into vba, I get an Expected End of Statement syntax error.

Could someone tell me what is wrong with this statement:

Docmd.OpenForm "Case_Action", acNormal, "", "[Case]=" &" '" [&CasePick] & "'", , acNormal

Thank you so much!

 

[bob fitz]

Just a guess, but try:

Docmd.OpenForm "Case_Action", acNormal, , "[Case]= '" & [&CasePick] & "'"

EDIT
I assume [Case] is a text field.

 

[vbaInet]

In addition, could &CasePick really be a field name?

 

[bob fitz]

In addition, could &CasePick really be a field name?

Good spot! I missed that.
Perhaps OP should try:
Docmd.OpenForm "Case_Action", acNormal, , "[Case]= '" & [CasePick] & "'"

 

[vbaInet]

It's possible it is bob because I don't think the macro converter will miss that, but weird.

 

[Kutach770]

Wow-thanks for responding so quickly. I will try your suggestion. Just to let you know the macro converter did include the & within the brackets. I can't imagine why the converter would create code with a syntax error. I'll let you know shortly.

 

[Kutach770]

It worked and I so appreciate it! Hopefully I can return the favor someday.

 

[bob fitz]

It worked and I so appreciate it! Hopefully I can return the favor someday.

And thank you for your kind words of appreciation. Glad you got it working. Good luck with your project.