Combo Box relating to Variable Criteria in Query

labbadabba · Mar 16, 2006

I have an unbound Combo Box in a form that I would like to use to set criteria in the query. How do I do this?

Ian Mac · Mar 16, 2006

The easiest way is:

Criteria:
Forms![YOURFORMNAME]![cboYOURCOMBONAME]

But not the best way. I don't like to bind queries to forms.

I prefer to create a function to pass the control value to on an event.

Code:

Public COMBOval As String

Public Sub SetCOMBOval(myCOMBO As Variant)
    
    If IsNull(myCOMBO) Then
        COMBOval = ""
    Else
        COMBOval = myCOMBO
    End If

End Sub

Public Function GetCOMBOval()

    GetCOMBOval = COMBOval
    
End Function

Changing the name COMBO to something you can use, e.g. PartDescription
Then using:

GetCOMBOval()

as your criteria.

I can expand on this if needed.

Hope that helps.

Cheers,

labbadabba · Mar 17, 2006

Interesting...I'll give that a shot. Thanks.

Combo Box relating to Variable Criteria in Query

labbadabba

Registered User.

Ian Mac

Registered User.

labbadabba

Registered User.

Similar threads

Users who are viewing this thread