Checkbox based on subform

[BerkshireGuy]

I have a form called Projects. A modal form is called updates. (I
didnt do a subform based on user requirements)

Obviously, a project can have many different updates.

One of this updates can be "Submitted To BSSP". If an project has
this type of update, an checkbox on the Projects form should be set to
true. The idea is that they dont want to have to open the updates form
to see that it has been submitted to BSSP.

I have some ideas to accomplish this, but would be interested in your
ideas.

Thanks
Brian

[Tom van Stiphout]

On Tue, 04 Sep 2007 20:42:26 -0700, BerkshireGuy
<be*************************@yahoo.comwrote:

In the Form_Close event of the modal dialog, write:
Forms!MyParentForm!MyCheckbox = (Me.MyDropdown = "Submitted to BSSP")

-Tom.

>I have a form called Projects. A modal form is called updates. (I
didnt do a subform based on user requirements)

Obviously, a project can have many different updates.

One of this updates can be "Submitted To BSSP". If an project has
this type of update, an checkbox on the Projects form should be set to
true. The idea is that they dont want to have to open the updates form
to see that it has been submitted to BSSP.

I have some ideas to accomplish this, but would be interested in your
ideas.

Thanks
Brian