Results 1 to 4 of 4
  1. #1
    accessnewb is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2011
    Location
    New York, NY
    Posts
    116

    Question Form doesn't open in Dialog mode

    I have a form with a field called ItemNo. On click of the item # a new form opens with the corresponding item #. This is the code I have written:



    DoCmd.OpenForm "F_Item", , , "Item='" & Me.Item & "'", , , acDialog

    The problem is, the form doesn't open in Dialog mode and it opens in the default form mode.

    Also, is there any way to make the fields in the form disabled? Like, if F_Item is opened by clicking the field ItemNo, then it must be disabled. In other circumstances (F_Item is the first form that is opened after login), the fields must be enabled.

    Hope I made myself clear.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    The WindowMode is the 6th argument of the OpenForm command. You have it as the 7th, which is the OpenArgs argument.

  3. #3
    accessnewb is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2011
    Location
    New York, NY
    Posts
    116
    Oh thanks! umm..now how do I disable the fields?

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Start a new thread, please.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 9
    Last Post: 04-04-2011, 11:13 AM
  2. Replies: 4
    Last Post: 01-14-2011, 10:37 AM
  3. Replies: 3
    Last Post: 12-09-2010, 11:50 AM
  4. Dialog box form example
    By pkstormy in forum Code Repository
    Replies: 0
    Last Post: 08-30-2010, 10:45 PM
  5. Open Form in Add Mode
    By Boreal2009 in forum Programming
    Replies: 2
    Last Post: 10-23-2009, 10:53 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
  •  
Other Forums: Microsoft Office Forums