Grig, Nice one, I had never thought about that as a solution. One to put in the "must remember" list
By the way, hope you are keeping well and business is good! Dave Crozier -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Grigore Dolghin Sent: 26 November 2009 09:04 To: [email protected] Subject: Re: Double click line in Grid to show order details Or, if you're using Visual FoxPro 9 and do the grid is non-editable, set the grid's .AllowCellSelection property to .F. then enter the code in grid's doubleclick. You need to make sure the code does execute if the grid contains at least one row. On Thu, Nov 26, 2009 at 10:59 AM, John Weller <[email protected]> wrote: > Hi Tina, > > I've done something similar. You need to put some code in every double > click event in the current control for each column - usually a textbox. The > code will be replicated in each row automatically. The code can be as > simple as DO myDetailsForm WITH OrderNo where OrderNo is the order number. > Your form would then seek the appropriate record in the Orders table and, > perhaps, select the detail records for that order. > > You could restrict it to just the column displaying the order no if you wish > for simplicity. You might also consider putting it in the Click event as > well to cover all eventualities. > > HTH > > John Weller > 01380 723235 > 07976 393631 > >> >> Hi everyone, >> >> I have a form that has a combo box with a list of clients. >> >> Choose a client and it does a little select into a temp >> cursor and then displays all orders for the client in a grid below. >> >> I want the user to be able to double click any one of these >> orders (rows in the grid) and bring up all detailed order >> information in a separate form. >> >> Before I go re-inventing the wheel... Has anyone done >> similar? Obviously the number of orders per client will >> vary. How do I set the double click rountine for every line >> that displays? It is possible isn't it? >> >> Tina >> > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] 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/10decf58c1e345d3a534735560e16...@develop ** 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.
