Problem with "blank" query

[Bob Richardson]

This Frame has 4 radio buttons. When the user clicks the first button
(option value=0) I want to display all records in the file. This works for
the other cases but not for Case 0. What's my problem?

Select Case Frame31.Value
Case 0 ' All Contacts
Qry = ""
Case 1 ' Presenters
Qry = "[PresenterYN] = Yes"
Case 2 ' Beach Watcher
Qry = "[BeachWatcher] = Yes"
Case 3 ' NewsLetter
Qry = "[NewsLetter] = Yes"
End Select
Me.Filter = Qry
Me.FilterOn = True

 

[Allen Browne]

Try turning the form's FilterOn property off to show all records:

Select Case Frame31.Value
Case 0 ' All Contacts
Me.FilterOn = False
Case 1 ' Presenters
Me.Filter = "[PresenterYN] = Yes"
Me.FilterOn = True
Case 2 ' Beach Watcher
...

 

[Bob Richardson]

Perfect. Thanks Allen.

Try turning the form's FilterOn property off to show all records:

Select Case Frame31.Value
Case 0 ' All Contacts
Me.FilterOn = False
Case 1 ' Presenters
Me.Filter = "[PresenterYN] = Yes"
Me.FilterOn = True
Case 2 ' Beach Watcher
...

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

This Frame has 4 radio buttons. When the user clicks the first button
(option value=0) I want to display all records in the file. This works
for the other cases but not for Case 0. What's my problem?

Select Case Frame31.Value
Case 0 ' All Contacts
Qry = ""
Case 1 ' Presenters
Qry = "[PresenterYN] = Yes"
Case 2 ' Beach Watcher
Qry = "[BeachWatcher] = Yes"
Case 3 ' NewsLetter
Qry = "[NewsLetter] = Yes"
End Select
Me.Filter = Qry
Me.FilterOn = True