Hi Lisa, It would take a little extra workflow but you could have the $Query-Search$ field default to something that will not return results. Then when the time is right replace that with your real search.
You could use 1=2. I just tried it out on a test form. I also logged it client-side and it looks like it is going to query the db (maybe it is late enough on Friday where most people are not looking at the List and the 1=2 reference won't start a riot :) ************************************ Fri Jul 30 2010 15:50:30.5980 */SELECT TOP 1001 T773.C1,C536870915,C536870964,C536870965,C536871324 FROM T773 WHERE (1 = 2) ORDER BY C536870915 ASC, 1 ASC Jason On Fri, Jul 30, 2010 at 12:07 PM, Kemes, Lisa < [email protected]> wrote: > ** > I have a table that gets populated by a field that I build my > query/search on. So my table qualification is: EXTERNAL( $Query-Search$) > (Query-Search being the name of my field). > > If there is nothing in this field and someone clicks on the table, then ALL > the data on that form gets pulled into that table! > > I was hoping that if nothing is in my query-search field then nothing would > be populated into that table. :( > > *Lisa Kemes** * > AR System Developer > Tyco Electronics > 717-810-2408 tel > 717-602-9460 cell > [email protected] > > > > _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
