Results 1 to 2 of 2
  1. #1
    gafoor is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Mar 2011
    Posts
    2

    Access Combo Box Refresh

    Dear Friends

    I want a macro or event to refresh combo box refresh.

    I have a customer Form, with a Post Office field data populated from Post Office Table/Form as a combo box.

    In Customer form , when try to enter new post office, it show the data is not in list.

    So I give a macro : not in list : open post office and enter new record there,
    I need that new record in my customer form , as a auto refresh.
    I dont want to close and reopen the customer form

    Pls. help me with a simple macro or event.

    Thanks



    GKC

  2. #2
    vdanelia is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2011
    Posts
    38
    you can use Me.Requery from the VBA

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

Similar Threads

  1. Refresh Form
    By tpcervelo in forum Forms
    Replies: 7
    Last Post: 02-07-2011, 08:03 AM
  2. Access novice help with refresh/requery
    By cvacgreg in forum Access
    Replies: 3
    Last Post: 02-04-2011, 08:51 PM
  3. Replies: 3
    Last Post: 10-04-2010, 01:31 PM
  4. refresh subform
    By asmith in forum Forms
    Replies: 5
    Last Post: 09-27-2010, 10:58 AM
  5. Error excel refresh from access
    By goyal in forum Access
    Replies: 0
    Last Post: 06-10-2009, 10:59 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