VBA Assistance

[jstevens]

This bit of code works and returns the table record row. I'm trying to pass a variable to the invoice number but encounter an error 2029.

Code: Select all

FoundInvoice = Evaluate("=Match(7030, apTable[Invoice],0)")

Here is the code to pass a variable. I used a Dim Statement to declare the data type but that erred as well.

Code: Select all

Invoice = 7030
FoundInvoice = Evaluate("=Match(Invoice, apTable[Invoice],0)")

[HansV]

You have to place the variable outside the quotes and concatenate:

Code: Select all

Invoice = 7030
FoundInvoice = Evaluate("=Match(" & Invoice & ", apTable[Invoice],0)")

[jstevens]

Thanks Hans!