DoCmd.OpenForm Compile Error, "Expected: ="

Asked Jun 21 '19 at 14:59

Active Jul 14 '20 at 08:30

Viewed 62 times

I am trying to run a simple DoCmd.Open Form code and I can't figure out the syntax. What is wrong with this code?

I have tried formatting the Where condition with and without quotes.

DoCmd.OpenForm("frm_InvoiceDetail",acNormal, , "[Invoice_]= '" & Me.txtInvNum & "'")

DoCmd.OpenForm("frm_InvoiceDetail",acNormal, , "[Invoice_]=" & Me.txtInvNum)

I just want to open the form where the Invoice number equal the invoice number of the clicked textbox. It is giving me a compile error expected:=

edited Jul 14 '20 at 08:30

braX

11,506
5
20
33

asked Jun 21 '19 at 14:59

K753

6

Ditch the parentheses, they don't belong there. – Erik A Jun 21 '19 at 15:01
Thank you @Erik A, that was the problem. It's working now. – K753 Jun 21 '19 at 15:05

DoCmd.OpenForm Compile Error, "Expected: ="

0 Answers0