Simple. Do a SQL Count first, using the same qualification as your statement but written as:
SELECT COUNT(*) FROM ...... Then have an Active Link trigger if this number is greater that 1. On the Open Window, use the qualification statement and have the Window Type set to Modify and the Display Type set to List Only. This should open the Results list as specified in the form's properties. An alternative is to do an Open Window to a new form that has a table field and pass the qualification, which you use with a EXTERNAL ($passedqualification$) in the table's qualification. This has the added benefit of allowing you to customize which columns are displayed. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
