argument not optional on CALL

[iankerry]

Hi

I hope someone can help. I am on Access 2010

I have a line that says

Call DoRemote (strEmail, arrSummaryData(i).strPromoterName, arrSummaryData(i).dtDatefield, arrSummaryData(i).strFilmName, arrSummaryData(i).strVenue, arrSummaryData(i).curAdultTP, arrSummaryData(i).curChildTP, arrSummaryData(i).curFamilyTP, arrSummaryData(i).strEventID)

When I run the code I get Argument not optional.

I have a Public Function called DoRemote. And I only have it once (searching the internet this was a possible problem)

There isn't a clue as to where the problem is -

Can anyone tell me where to start looking? Is the error in the Call DoRemote line or might it be in the DoRemote Function?

many thanks.

ian

 

[pbaldy]

The first thing I'd check is that you're passing all the required parameters. If the function expects 10 and you only pass 9, you'll get that error. What does the function look like (just the first line with the parameters in it)?

 

[iankerry]

Spot on Paul! Many thanks. I did indeed have one missing.

Really appreciate your help.

Ian

 

[pbaldy]

Happy to help Ian. With that many, it can be easy to miss one.