Function - Returning a Value

[dreamnauta]

Hello Everyone,



I have a simple logic error here i'm sure, somewhere here. I am trying to return a string from this function. Any help is appreciated!

Function FindExportQuery(Optional numberInput As Integer)

If IsMissing(numberInput) = True Then

    If Me.radioGroup.Value = 3 And listBox.ListCount = 0 Then
        strQueryName = "Degree_Completions_No_CIP"
    
    ElseIf Me.radioGroup.Value = 2 And listBox.ListCount = 0 Then
        strQueryName = "Enrollment_Data_No_CIP"
 
    ElseIf Me.radioGroup.Value = 3 And listBox.ListCount > 0 Then
        strQueryName = "Degree_Completion_Results"
      
    ElseIf Me.radioGroup.Value = 2 And listBox.ListCount > 0 Then
        strQueryName = "Enrollment_Results"
    End If
    
Else

    If numberInput = 1 Then
        strQueryName = "Degree_Completions_No_CIP"

    ElseIf numberInput = 2 Then
        strQueryName = "Enrollment_Data_No_CIP"

    ElseIf numberInput = 3 Then
        strQueryName = "Enrollment_Results"

    ElseIf numberInput = 4 Then
        strQueryName = "Degree_Completion_Results"
    End If
End If

FindExportQuery = strQueryName

End Function

[pbaldy]

The return should be specified, like here:

http://www.baldyweb.com/Function.htm

but unspecified will be a Variant, so that should still work. How are you calling it?

[June7]

What is error message? Have you step debugged? What line fails?

According to Access Help, IsMissing requires Variant type as input.
"IsMissing does not work on simple data types (such as Integer or Double) because, unlike Variants, they don't have a provision for a "missing" flag bit."

This makes sense because declared number variables initialize with 0 value, string variables initialize with empty string, boolean initialize as False. So number and boolean variables would never be missing a value. The empty string will also probably not meet the missing condition.

[dreamnauta]

Ahh k thank you. There are no errors from the function itself, must be the way I called it. Thanks for the information on isMissing() !