Requerying on close of dialog form - optional?

[Historypaul]

I use a very typical setup a lot. I have the information displayed, but uneditable and there is a "new" button at the top of the list or form if the user wants to add something new. Very simply, the code is DoCmd.OpenForm "blah blah blah", after which, there is a Me.Requery.



What I'd really like to do is skip the requery if the user didn't add a new record on the form that they opened... I have it currently, where the user just enters any new info they want, and hit the corner close button - not a dual "OK/Cancel" arrangement. But even if I did have a dual OK/Cancel button arrangement on my popup, how would I let the main form know which was pressed so it could determine whether or not a requery was necessary? Is there a simply way to pass a variable from the open dialog window back to the procedure kind of like passing openargs from the form to the dialog initially? I could then just use the "After Insert" event of my dialog window to set the state of that variable (probably true/false) if the user does actually add a record. Any ideas?

[pbaldy]

No built-in way to pass a variable back, but you could set a global variable and test that.

[Rawb]

While you can pass variable information INTO another Form (for example, when you click a button to open a Form, you could pass information), you can't really return anything back the other way.

In this instance, however, I think we can simulate it by just having the OK button on your popup Form perform the Requery on your main Form.

The following code snippit makes several assumptions:

• Your main Form is called frmSwitchboard.
  
• Your popup form is called frmAddRec.
• The "OK" Button on frmAddRec is called btnOK.
• You only call frmAddRec from frmSwitchboard.

Example code:

Private Sub btnOK_Click
    Forms!frmSwitchboard.Requery
    DoCmd.Close acForm, Me.Form.Name
End Sub

If you happen to open frmAddRec from multiple "main" Forms, you can still do it, but the Requery portion of the code is a little more complex.