Issue with a checkbox when control passes back to calling form

[Goot]

I have a form with a bunch of check boxes. When the user selects the checkbox, another form opens, and they fill in info. What I am looking to do is...when the user deletes the record on the second form and control passes back to the calling form, I want the checkbox to remove the check.

What happens now is when they come back to the main form after deleting records, the check box still has the check in it. Can I set the value to 0 and refresh the form...or is there a better way....

Thanks

 

[rubbernilly]

If all the checkbox does is open the form, then you could just as well have a commandbutton.

But it sounds like you are trying to have master/slave information for a record without using subforms. How is the information on the second form tied to the first form? And if the user does NOT delete the record from the second form but rather saves it, does the checkbox stay checked on the first form?

 

[Goot]

The information on the second form is tied to the first form via LinkID to the ID of the first form. If the user does not delete the record from the second form, but rather saves or edits it, then the checkbox stays checked on the first form, and that's what we would want.

Thanks

 

[rubbernilly]

It sounds as if you are not normalized.

If you have a checkbox to indicate that the Record has a secondary set of data in another table (linked via the LinkID), then that sounds as if you can have only one entry in the other form. In that case, why not have the fields from the secondary data on the first form and in the primary table?

If, on the other hand, you can have multiple records in the second table that are tied to the first, then a checkbox isn't your best bet. I would suggest a subform control whose sourceobject is your second form and which has LinkChild and LinkMaster fields set. You can do multiple subforms, and if you need room, you can utilize a tab-control to have multiple tabs, one subform per tab.

But maybe I still don't understand enough about your situation.