Frame Case Value Question 1

[ccepaulb]

The following code is attached to a text box from which my query recieves it's criteria. The first four cases work great, the problem is that I would like for case 5 to return all records regardless of the tier value in the record. Is there a way to write a wildcard into the case 5 text box value? I tried "*" and * and All, but none worked.

Private Sub [FrameName]_AfterUpdate()
Select Case Me.[Framename].Value

Case "1"
[TextBox].Value = "tier1"
Case "2"
[TextBox].Value = "tier2"
Case "3"
[TextBox].Value = "tier3"
Case "4"
[TextBox].Value = "tier4"
Case "5"
[TextBox].Value = ""
End Select

End Sub

Thanks, Paul

 

[randy700]

Your query's criteria is probably something like this...
=forms!frmWhatever!txtWhatever

Try changing it to...
LIKE forms!frmWhatever!txtWhatever

Then, in your case statement, use the *.


Randy

 

[ccepaulb]

Bingo!!! You are the man, that was driving me crazy