Update field on calling form (1 Viewer)

[JohnPapa]

I have a form A which displays, among other things, the value of a field based on some table values.

Form A calls Form B which calls Form C which changes the table values, which affects the field value on Form A.

I tried using acDialog when I open Form B and Form C, but when I do this Form C appears behind Form B. I also tried setting Popup to true for the forms but that did not help.

Essentially what I want to do is execute some code in Form A once I return from Forms B & C, to update the specific field on Form A.

 

[bob fitz]

I tried using acDialog when I open Form B and Form C, but when I do this Form C appears behind Form B...........

If both B and C are opened, using the acDialog argument, then whichever is opened last should stay "On Top". Double-check that you did set the acDialog argument of DoCmd.OpenForm when opening both B and C.

 

[JohnPapa]

If both B and C are opened, using the acDialog argument, then whichever is opened last should stay "On Top". Double-check that you did set the acDialog argument of DoCmd.OpenForm when opening both B and C.

Yes it worked. I swear I tried it many times. Maybe my pc was in a weird state, as I was having other problems as well.

 

[gemma-the-husky]

The simplest way to update the value on form A is Me.requery, although it depends what processing you need to do. Also me.requery might change the active record shown by form A.

The value may even change without doing anything at all.

 

[JohnPapa]

The simplest way to update the value on form A is Me.requery, although it depends what processing you need to do. Also me.requery might change the active record shown by form A.

The value may even change without doing anything at all.

There is some code that is executed in the Open event of the form, so Form_Open(0) could be used.

 

[moke123]

Something like this maybe?

Dim WithEvents MyForm2 As Access.Form

Private Sub Command0_Click()

    DoCmd.OpenForm "Form2"

    Set MyForm2 = Forms("Form2")
    MyForm2.OnClose = "[Event Procedure]"
    MyForm2.Modal = True

End Sub

Private Sub MyForm2_Close()

    MsgBox "Do something here when form2 closes"

    Set MyForm2 = Nothing

End Sub

 

[MajP]

Here is a little more explanation of when and why to use ACDIALOG or what @moke123 suggests, and what are the impacts of each.
ACDIALOG does not equate to simply modal, pop up. There is more to it.

Solved - Returning from acDialog

I have Form A that calls Form B as a dialog so that when it returns it can run code determining ID, etc. On form B is a button that prints one label. But because form B is made invisible for that one label, Form A thinks it's finished and pops up in front of the label. Is there no way of calling...

www.access-programmers.co.uk