sammers101
Registered User.
- Local time
- Yesterday, 23:36
- Joined
- May 11, 2012
- Messages
- 89
I have a datasheet that is filtered when you click any of a few buttons
I use browseTo. A few of the buttons will show the quick filter list. The code for the browseTo is all the same except for the where condition field.
The buttons with these codes does not show a drop down list when I try to filter my datasheet even further (only shows text filters):
Button 1's where condition: [statusID]<10 And ([focDate]-6<=Date() Or IsNull([focDate]))
Button 2's where condition: [statusID]<10 And ([shipDate]-6<=Date() Or IsNull([shipDate])) And ([focDate]-6<=Date() Or IsNull([focDate]))
However, the buttons with this code shows the drop down list:
Button 3's where condition: [statusID]<10
I use browseTo. A few of the buttons will show the quick filter list. The code for the browseTo is all the same except for the where condition field.
The buttons with these codes does not show a drop down list when I try to filter my datasheet even further (only shows text filters):
Button 1's where condition: [statusID]<10 And ([focDate]-6<=Date() Or IsNull([focDate]))
Button 2's where condition: [statusID]<10 And ([shipDate]-6<=Date() Or IsNull([shipDate])) And ([focDate]-6<=Date() Or IsNull([focDate]))
However, the buttons with this code shows the drop down list:
Button 3's where condition: [statusID]<10