Saving a value on a form -- from another form

[Goot]

I have a form (form 1) that calls another form (form2).
Users can change and save info on form2. When they save the form2 record, I check off a check box on form 1.
Forms!frmAccount!(Me.txtCheckType.Value) = 0

However, when control passes back to form1, the user might cancel the form, or close the form, in that case, I lose the value from the above statement.

How can I get that value to "stick" from form2.

 

[BoxHead]

If the checkbox status is related to a specific record, you could have that value stored in a table with the record. If it's just a general 'this-is-where-we're-at-in-the-process' value, you can declare it as a public variable and use code to change the variable rather than tick a checkbox. Use the checkbox to reflect the value of the public variable rather than to set the value.

HTH


John

Use what you have,
Learn what you can,
Create what you need.

 

[Goot]

Form 1 has a save button on it, I would really like to invoke that save button right after I set the value of the checkbox. Is there a way to do it from form2.

I have tried a few different variations for instance
Call Forms.frmAccount!(Me.cmdSave)

Thanks

 

[BoxHead]

cmdSave_Click

is what I usually use to call the click event of a save button.

HTH

John

Use what you have,
Learn what you can,
Create what you need.