Problem with "blank" query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bob Richardson - 21 Nov 2005 23:48 GMT

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

Reply to this Message

Allen Browne - 22 Nov 2005 00:32 GMT

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
...

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
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
[quoted text clipped - 12 lines]
> Me.Filter = Qry
> Me.FilterOn = True

Reply to this Message

Bob Richardson - 22 Nov 2005 00:59 GMT

Perfect. Thanks Allen.

> Try turning the form's FilterOn property off to show all records:
>
[quoted text clipped - 23 lines]
>> Me.Filter = Qry
>> Me.FilterOn = True

Reply to this Message