Results 1 to 4 of 4
  1. #1
    corystemp is offline Novice
    Windows Vista Access 2007
    Join Date
    Mar 2009
    Location
    Kennewick,Wa
    Posts
    14

    Combo box problem

    I have an "add new record" buttong on my database that starts a new entry when i click it. The problem is that after i click the new button and add a new entry it doesnt add it to my combo box untill after i close and reopen the form. how can i change my combo box to add the new entry when i first enter it so i dont have to constintly close and open the form?



    help PLEASE!!!

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,640
    Once the record has been added, you can requery the combo.

    Me.ComboName.Requery
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    corystemp is offline Novice
    Windows Vista Access 2007
    Join Date
    Mar 2009
    Location
    Kennewick,Wa
    Posts
    14
    sorry pretty new to this, can you explian how i do that? thanks

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,640
    To start using code:

    http://www.baldyweb.com/FirstVBA.htm

    I'd probably use the On Current event of the form for this.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. problem with combo box
    By ds_8805 in forum Forms
    Replies: 2
    Last Post: 03-24-2010, 10:02 PM
  2. combo box problem
    By ngeng4 in forum Forms
    Replies: 15
    Last Post: 03-23-2010, 09:03 PM
  3. Combo Box problem
    By Rick West in forum Forms
    Replies: 3
    Last Post: 03-18-2010, 04:42 PM
  4. Combo box look-up problem
    By Samdaman in forum Forms
    Replies: 0
    Last Post: 12-14-2009, 02:54 PM
  5. Problem with combo box
    By osimini in forum Forms
    Replies: 5
    Last Post: 05-25-2009, 03:08 PM

Tags for this Thread

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