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 > _______________________________________________ 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/ea07f892c4244c708404f1130fadf...@wessex1 ** 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.

