Pass Values from One Form To Another

[jmcleod]

I have a database that I am creating to enter risks and controls in for business auditing. I am stuck with a problem related to passing a value from one form to another. The general idea behind the database is this: A business enters its risks into a risk form and later enters its controls in the controls form. These are separate forms because the risk and controls may be entered at different times by different auditors. An example of what this looks like is this:


Risk – Real estate owned by the company may be overvalued on the company’s balance sheet.
Control – Once every two years, the company obtains an independent appraisal of the property’s value.

A risk may have more than one control mapped (assigned) to it. A control may be assigned to more than one risk.
Now that we know what the end result looks like, here is my problem.

Currently, I use a form to display the risk. This form has a subform on it which displays the control. I use a combo box on the subform to choose the control’s ID reference number. When chosen, the control appears in the subform. This form then populates a join table which now contains the foreign key identifiers of both the risk and the control or controls. The problem is that the controls are wordy and stored in memo fields, so the user has to choose the control’s identifier in the combo box, which is usually not know to the user. So, I have a button on the form the user can select and a report of all controls pops up so the user can scroll through and find the desired control and get its reference ID. They then close the pop up report and choose the reference ID in the combo box.
What I would like to do is to have the pop-up report appear as a form and each control had a checkbox next to it. Then the user could just check the box for the control they wanted. No more selecting reference IDs from the combo box.

If I need to I can post more details about the forms and tables, but for now, is what I want to do possible, and if so, how would I go about achieving this.
Thanks in advance for your help.

[June7]

The popup form would be bound to table and displaying records associated with the record on the risk form? The checkbox would have to be bound to a yes/no field in table. Actually, really only have to select the control record and then code can do something with that reference ID. One approach is for code behind the popup to set the value of the combobox.