Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

More Than 1 In One Query Criteria

Discussion in 'Information Technology' started by msmuzila@gmail.com, Jul 28, 2006.

  1. msmuzila@gmail.com

    msmuzila@gmail.com
    Expand Collapse
    Guest

    I have a query that takes information from a combo box. Right now that
    is a single value. I need a way to inclue multiple values

    Here is the query criteria and the function behind it: GetCombo30(33)

    Public Function GetCombo30(ByVal lngID As Long) As Long
    On Error Resume Next
    Dim lngCombo30 As Long

    ' You'll need an IsLoaded or equivilent function
    If CurrentProject.AllForms("Product_Sales_Monthly").IsLoaded Then
    lngCombo30 = Forms!Product_Sales_Monthly!Text42
    Else
    lngCombo30 = lngID
    End If

    GetCombo30 = lngCombo30
    End Function
     
  2. Loading...


Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     


Share This Page