Using a Pop-up form for data entry from sub-form

[OtakiriLad]

I am attempting to develop a recipe database with a fewbells and whistles more than the standard fare.


In its simplest form I want a data entry presentation thatshows the base recipe details together with a subform being a list of unboundhighly formatted ingredients. When you click on an individual ingredient lineitem a form appears allowing addition/update of the ingredient details.


The reason for the unbound items is that I want to showgrammatically correct formatting eg show ‘1 onion’ but ‘2 onions’ or ‘3/4 cup’but ‘1 1/2 cups’. The underlying database will contain ‘type’ tables containingthe singular and plural versions of unit of measure, ingredient item etc. Thepop-up form will have combo boxes presenting both so for unit of measure willshow ‘cup/cups’.


My problem is for a new line item, how do I populate theintended foreign key to the parent recipe table in the pop-up form as it is nullin the unbound record at the time of the ‘on click’ event.


I imagine such a situation could exist in variousapplications (Customers and Orders, Students and Courses, etc) but I haven’tbeen able to find a case where a pop-up form is used for the child data entry.


Any suggestions are welcome.
Dave

[June7]

This has been topic of discussions before. Various ways to accomplish.

1. pass ID to opening form with OpenArgs

2. set a global variable or a TempVar variable

3. popup form references control on calling form

[OtakiriLad]

Thank you kind sir, the global variable option did the trick.

Dave