Results 1 to 4 of 4
  1. #1
    raffi is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    Mar 2014
    Location
    Inside a Sub Procedure
    Posts
    88

    combo-box list items edit form

    hello i have a combo-box and have set allow value list edits : enabled, and i have a set a form to go to, how can i open the form to go to in dialogue view ? trough the combo-box edit new item ?

  2. #2
    burrina's Avatar
    burrina is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383
    Try this.

    DoCmd.OpenForm “FormName”, , , , , acDialog
    or:
    DoCmd.OpenForm “FormName”, WindowMode:=acDialog

    DoCmd.OpenForm MyComboBox, acViewNormal
    HTH

  3. #3
    raffi is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    Mar 2014
    Location
    Inside a Sub Procedure
    Posts
    88
    um, where am i supposed to write that again ? .. lol im sorry im new to vba ..

  4. #4
    burrina's Avatar
    burrina is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383
    OnOpenEvent for your form.
    OnClickEvent for your ComboBox.

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

Similar Threads

  1. Replies: 9
    Last Post: 09-09-2013, 03:56 AM
  2. Replies: 2
    Last Post: 05-31-2013, 03:27 PM
  3. Write "Edit List Items.." data back to original form.
    By ngahm in forum Database Design
    Replies: 33
    Last Post: 02-27-2012, 06:54 PM
  4. Replies: 4
    Last Post: 04-05-2011, 06:12 PM
  5. Edit List Items
    By Broderhol in forum Forms
    Replies: 3
    Last Post: 02-23-2011, 05:51 PM

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