Forum Discussion

Tony2021's avatar
Tony2021
Steel Contributor
Mar 16, 2022

Open Form acDialog

    Hello Experts, I have the below code firing on my main form. When the main form opens, the other forms in teh code open if Dcount>0. I have noticed that the forms open all at once and not on...
access
  • arnel_gp's avatar
    arnel_gp
    Mar 17, 2022

    actually there are Errors in your code!
    did you disable error checking?

    see your sample:

    DoCmd.OpenForm "frmNotifications", WindowMode:=acDialog

    did you noticed what is wrong?
    if not then, here you define WindowMode:=acDialog, but, did you define the FormName?

    should be:

    DoCmd.OpenForm FormName:="frmNotifications", WindowMode:=acDialog

     

    for the acFormDS form:

     

    DoCmd.OpenForm FormName:="frmNotificationsDateCheck", View:=acFormDS, WindowMode:=acDialog


    do it with the rest of your code.

arnel_gp's avatar
arnel_gp
Steel Contributor
Mar 17, 2022

actually there are Errors in your code!
did you disable error checking?

see your sample:

DoCmd.OpenForm "frmNotifications", WindowMode:=acDialog

did you noticed what is wrong?
if not then, here you define WindowMode:=acDialog, but, did you define the FormName?

should be:

DoCmd.OpenForm FormName:="frmNotifications", WindowMode:=acDialog

 

for the acFormDS form:

 

DoCmd.OpenForm FormName:="frmNotificationsDateCheck", View:=acFormDS, WindowMode:=acDialog


do it with the rest of your code.

  • Tony2021's avatar
    Tony2021
    Steel Contributor
    Mar 17, 2022
    Arnel, that did it. Perfect. thank you again for the help!

Resources