Results 1 to 6 of 6
  1. 10-03-2018, 01:03 PM #1
    sparker75
    sparker75 is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Jul 2018
    Posts
    107

    Open a form in Dialog

    Hello,

    Im trying to open a form as a popup and was wondering how to code it. I would also like to match two variables - OrderNum and Oper


    This is what I have so far with just the one variable OrderNum



    DoCmd.OpenForm "frmOrderOpertationsLongTxt", acDialog, , "OrderNum =" & Me.OrderNum
    Reply With Quote Reply With Quote
  2. 10-03-2018, 01:58 PM #2
    GinaWhipp's Avatar
    GinaWhipp
    GinaWhipp is offline Competent Performer
    Windows 7 64bit Access 2013 32bit
    Join Date
    Jul 2011
    Location
    Ohio, USA
    Posts
    377
    acDialog on wrong place...

    DoCmd.OpenForm "frmOrderOpertationsLongTxt", , , "OrderNum =" & Me.OrderNum, , acDialog
    Reply With Quote Reply With Quote
  3. 10-03-2018, 02:03 PM #3
    sparker75
    sparker75 is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Jul 2018
    Posts
    107
    Great! Thank you. Do you know how I add the second variable to this line?

    "Oper =" & Me.Oper


    DoCmd.OpenForm "frmOrderOpertationsLongTxt", , , "OrderNum =" & Me.OrderNum, , acDialog
    Reply With Quote Reply With Quote
  4. 10-03-2018, 03:06 PM #4
    pbaldy's Avatar
    pbaldy
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    DoCmd.OpenForm "frmOrderOpertationsLongTxt", , , "OrderNum =" & Me.OrderNum & " AND Oper =" & Me.Oper, , acDialog
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com
    Reply With Quote Reply With Quote
  5. 10-03-2018, 03:23 PM #5
    sparker75
    sparker75 is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Jul 2018
    Posts
    107
    Thank you everyone!
    Reply With Quote Reply With Quote
  6. 10-03-2018, 04:11 PM #6
    pbaldy's Avatar
    pbaldy
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    Gina was happy to help and I was happy to jump in while she was offline.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. want dialog form to open in datasheet view
    By gunitinug in forum Access
    Replies: 2
    Last Post: 09-04-2017, 08:13 PM
  2. Button in form to open Import Excel Spreadsheet dialog box is not working
    By Fannes in forum Forms
    Replies: 7
    Last Post: 10-24-2016, 01:55 AM
  3. Open Form in Dialog mode in Add NewRecord
    By JrMontgom in forum Programming
    Replies: 1
    Last Post: 02-08-2015, 06:47 PM
  4. Open form as dialog box and in specified position
    By Fredrik831 in forum Programming
    Replies: 3
    Last Post: 11-30-2012, 08:28 AM
  5. Form doesn't open in Dialog mode
    By accessnewb in forum Programming
    Replies: 3
    Last Post: 08-02-2011, 08:38 AM

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums