Prev: Tabs disappear on tab contgrol
Next: limit screen updating
From: Mark Kubicki on 19 Apr 2010 18:55
I have the following code:

Dim stDocName As String
Dim stLinkCriteria As String
strOpenArgs = "true" & "~" & Me![Manufacturer] & "~" & Me![CatalogNo]

stDocName = "frmFixtureInstallationNotes"
stLinkCriteria = "[Manufacturer] = '" & Me.Manufacturer & "' AND
[CatalogNumber] = '" & Me.CatalogNo & "'"

DoCmd.OpenForm stDocName, , , stLinkCriteria, , acDialog, strOpenArgs

------------
I want the code to pause executing HERE until the called form is closed
HOWEVER, when I use as Dialog, nothing executes afterwards, and yet when I
use acNormal (although I don't want it to, the code continues...
------------

Call DoSQLDeleteBaseInstallationNotes(Forms![frmSpec])
Call DoSQLAddBaseInstallationNotes(Forms![frmSpec])
Forms![frmSpec].chldInstallationNotes.Requery
more code....



any thoughts would be greatly appreciated in advance,
mark


From: Jeanette Cunningham on 19 Apr 2010 20:58
If you put a msgbox

MsgBox "Dialog form now closed"
as shown below, it will help you debug.

Dim stDocName As String
Dim stLinkCriteria As String
strOpenArgs = "true" & "~" & Me![Manufacturer] & "~" & Me![CatalogNo]

stDocName = "frmFixtureInstallationNotes"
stLinkCriteria = "[Manufacturer] = '" & Me.Manufacturer & "' AND
[CatalogNumber] = '" & Me.CatalogNo & "'"

DoCmd.OpenForm stDocName, , , stLinkCriteria, , acDialog, strOpenArgs
MsgBox "Dialog form now closed"

You should see the msgbox when you close the dialog form.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

"Mark Kubicki" <Mark(a)TillotsonDesign.com> wrote in message
news:OMgo3NB4KHA.1452(a)TK2MSFTNGP06.phx.gbl...
>I have the following code:
>
> Dim stDocName As String
> Dim stLinkCriteria As String
> strOpenArgs = "true" & "~" & Me![Manufacturer] & "~" & Me![CatalogNo]
>
> stDocName = "frmFixtureInstallationNotes"
> stLinkCriteria = "[Manufacturer] = '" & Me.Manufacturer & "' AND
> [CatalogNumber] = '" & Me.CatalogNo & "'"
>
> DoCmd.OpenForm stDocName, , , stLinkCriteria, , acDialog, strOpenArgs
>
> ------------
> I want the code to pause executing HERE until the called form is closed
> HOWEVER, when I use as Dialog, nothing executes afterwards, and yet when I
> use acNormal (although I don't want it to, the code continues...
> ------------
>
> Call DoSQLDeleteBaseInstallationNotes(Forms![frmSpec])
> Call DoSQLAddBaseInstallationNotes(Forms![frmSpec])
> Forms![frmSpec].chldInstallationNotes.Requery
> more code....
>
>
>
> any thoughts would be greatly appreciated in advance,
> mark
>
>


 | 
Pages: 1
Prev: Tabs disappear on tab contgrol
Next: limit screen updating