I am receiving the error "wrong number of arguments" when I try to call a
function from a text box. I am trying to put =BuildCriteria() in the contol
source.
The function it is calling is on the form and is as follows:
************************
Public Function BuildCriteria() As String
If Len(Me.CurrAuditor) > 0 Then
BuildCriteria = BuildCriteria & Me.CurrAuditor
End If
If Len(Me.VendorName) > 0 Then
BuildCriteria = BuildCriteria & Me.VendorName
End If
If Len(Me.Platform) > 0 Then
Build Criteria = BuildCriteria & Me.Platform
End If
End Function
************************
I've used this function sucessfully in other places so I am not sure where I
am having an issue.
Thanks!
raskew - 27 May 2008 21:20 GMT
BuildCriteria() is a built-in Access function. Check your help file.
Bob
>I am receiving the error "wrong number of arguments" when I try to call a
>function from a text box. I am trying to put =BuildCriteria() in the contol
[quoted text clipped - 23 lines]
>
>Thanks!
querykitty - 27 May 2008 21:34 GMT
Thank you, that did it!
> BuildCriteria() is a built-in Access function. Check your help file.
>
[quoted text clipped - 27 lines]
> >
> >Thanks!