Results 1 to 3 of 3
  1. #1
    raychow22 is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    May 2017
    Posts
    145

    Requery After Update


    I need a vba code after update on a field that affects another requery field. The problem is that if I reselect (dropbox) the first field; the afterupdate code does not erase the second field (if I have chosen something before). What can I add to the requery of the second field to clear its first selection?

  2. #2
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Can you give examples? Requery is a command and will be executed regardless, so I am not sure of the exact process you are trying to accomplish.

  3. #3
    davegri's Avatar
    davegri is online now Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,741
    In the after_update event of the first field include:
    Code:
    second_field = vbnullstring

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

Similar Threads

  1. After Update ReQuery and update text box
    By Eddy Sincere in forum Forms
    Replies: 4
    Last Post: 04-09-2015, 03:41 PM
  2. Requery Does Not Update Listbox Row Source
    By szucker1 in forum Forms
    Replies: 7
    Last Post: 02-11-2014, 08:58 AM
  3. Requery does not update combo box
    By pbouk in forum Forms
    Replies: 1
    Last Post: 03-25-2013, 03:01 PM
  4. Requery subform after update of main form
    By gemadan96 in forum Forms
    Replies: 3
    Last Post: 10-17-2012, 02:33 PM
  5. after DAO update, listbox.requery not refreshing
    By EuniceH in forum Programming
    Replies: 2
    Last Post: 10-21-2011, 04:16 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