I would like to use the information on one form to create a result set and open it up on another form.  Can I do this, and if so, how?

The specifics of my situation are that I have a one-to-many relationship which is not implemented using subforms.  This is intentional, particularly because I don't want the user to be able to create child records from the parent record, and partly because the child records are themselves complex (as they have children and complex business logic).  Thus, I'd rather just present a simple list of child records on the parent record, and then allow the user to be able to select a particular child record and click a button to edit it by bringing up a form from the child record's database.  I'm going to use a list box as my presentation object.  I just can't figure out how, once the user selects an item in the list box, to bring up the appropriate child record in Update mode.

Hammer wrote on Nov 28^th, 2007 at 2:24am:

Tricky.  Now I see where the On Form Reveal event can come in handy.  What are the odds we'll see 2.0.4 in the next week or so?  Otherwise, I may have to use your old school method.