Use Recordset in Function 1

[TimTDP]

In Access 2000, I have created the following function:
Function ComparePrices(AgencyID As Integer, _
ImportOrganisationId As Integer, _
CifOrFob As String)

I want to call the function using the result of a recordset like this:
ComparePrices 1,2,[rstCosting]![CostingType]

When I compile the code I get the error "Argument not optional".

What am I doing wrong?

 

[Golom]

Could be that functions return values and you are not providing a place to receive the value

[red]myValue = [/red]ComparePrices [red]([/red]1,2,[rstCosting]![CostingType][red])[/red]

You should also be explicit about what type of variable should be returned by the function

Function ComparePrices(AgencyID As Integer, _
                       ImportOrganisationId As Integer, _
                       CifOrFob As String)[red] As ????[/red]

As it stands, your function will return a variant.

 

[IrishJim]

Could it be that in some cases
"[rstCosting]![CostingType]" evaluates to a null?

IrishJim