Friends I've noticed this before but I've shrugged my shoulders. Can someone help me
Lets' say I have 2 tables, Clients and Trans I have a form with a Grid, and a command button This command button goes something like select * from trans where client="ABC" and between(date,X,Y) into able temp set relatio to clcode into Clients go top report form (myreport) preview nocons set rela to use sele clients thisform.refresh There are no clients ......................... I have to exit the form and start the form again -- Regards Sytze de Boer Kiss Systems Ph: 64-7-8391670, Mob:021 937611, Skype: kissman2 www.kiss.co.nz _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.