Q
querykitty
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!
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!