no selected value on list box

[romanticode]

how can i filter my query, so if no list box item selected. the query will show all data.

thnks

 

[missinglinq]

IF you want the query to show all data you simply run it without filtering it!

Private Sub RunQueryButton_Click()
  If IsNull(Me.YourListBox) Then 
    'Run query unfiltered
  Else
    'Run filtered query
 End If 
End Sub

 

[ajetrumpet]

how can i filter my query, so if no list box item selected. the query will show all data.

thnks

This is classic example of what Jon K's FAQ demonstrates. I believe the "technical" name for this process is Query by Form. Queries that are run from form criteria can return all results by using the following SQL line (as many times as needed (for as many controls as the criteria section references))...

WHERE ([field] = Forms!FormName!ControlName OR
   Forms!FormName!Control IS NULL) AND ([color=red]Repeat the line here if needed[/color])