Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2010
    Posts
    134
    Provided Answers: 1

    Unanswered: acDialog won't open as Dialog

    HI

    I am using the following code from a subform and want to see my 'Phase' form open in dialogue mode. As it stands, it is opening in a full page.

    Any hints?

    Private Sub Text21_Click()
    DoCmd.OpenForm "frmPhaseDates", acViewFormDialog, , "[Phase] = '" & Me.Phase & "'"

    End Sub

    I have also tried this but the same thing happens

    Private Sub Text21_Click()
    DoCmd.OpenForm "frmPhaseDates", acDialog, , "[Phase] = '" & Me.Phase & "'"

    End Sub


    Any help greatly appreciated.

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Check help; you have that in the wrong position. You want it in the windowmode argument.
    Paul

  3. #3
    Join Date
    Dec 2010
    Posts
    134
    Provided Answers: 1
    I have been coming on this forum for quite a while now and you are constantly there getting it right .... awesome job. Thank you so so much.

    Private Sub Text21_Click()
    DoCmd.OpenForm "frmPhaseDates", , , , , acDialog, "[Phase] = '" & Me.Phase & "'"
    This works. I didn't realise it needed so many additional commas in there.

    Have a great weekend.

  4. #4
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Happy to help!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •