Results 1 to 3 of 3
  1. #1
    CementCarver's Avatar
    CementCarver is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2013
    Location
    Canada
    Posts
    231

    Only After Closing Form does newly created record display via Combo Box

    Finally got my code to work for creating a new record and have used the refresh option to update the combo box to display the business name just created.



    The problem is, is that after selecting the business name from the combo box, the associated record won't display in my MEMBERS form.

    Only after I close the form and reselect it again, does the new business name populate after it has been selected via the combo box again.

    Am I missing a step somewhere to refresh the records associated with this table?

    Do I need to refresh the initial query that I used to create the form with?

    If so, how can this be accomplish via VB code?

    Thx...CementCarver

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    Thread already marked solved - is it?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    CementCarver's Avatar
    CementCarver is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2013
    Location
    Canada
    Posts
    231
    Yes it is.

    CC

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

Similar Threads

  1. Replies: 7
    Last Post: 03-12-2013, 07:18 PM
  2. Replies: 8
    Last Post: 11-13-2012, 03:36 PM
  3. Replies: 7
    Last Post: 04-27-2010, 10:29 AM
  4. New Field Name on Newly created query
    By inan25 in forum Queries
    Replies: 3
    Last Post: 05-13-2009, 09:05 PM
  5. Best Way to Return a Newly Created Index?
    By Jerimiah33 in forum Programming
    Replies: 5
    Last Post: 09-06-2006, 12:22 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