Results 1 to 2 of 2
  1. #1
    TenOc is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    Feb 2015
    Posts
    94

    Combo Box does not track display on Form.

    I am a newbie so excuse me if I use the wrong words.



    I have a form with sub-forms see attached screen shot. I use an unbound combo box to select "Find Beneficiary" that is "DName" from a table/query. The following SQL is the row source for the combo box.

    SELECT tabBenef.DName
    FROM tabBenef
    ORDER BY tabBenef.[DName];

    All works OK except for one problems.

    Click image for larger version. 

Name:	ComboError1.png 
Views:	13 
Size:	213.5 KB 
ID:	38158 Click image for larger version. 

Name:	ComboError2.png 
Views:	12 
Size:	283.8 KB 
ID:	38159

    When I move to a different record using the record navigator arrows at the bottom of the screen the combo box displays the old name. See second screen shot.

    I have tried to requery the form and also the combo box with no joy. The "DName" tracks correctly but the fact that the combo box does not agree with the DName field is somewhat confusing.

    Any suggestion on how to blank out the name in the combo box or make it display the correct DName?

    Since the SQL query does not have a name, I can not re-run it.

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Should have posted what you tried. Me.Requery won't requery a main form from a sub form.
    Requery should have worked as far as I can tell, but since it didn't, you could try setting it to "" - probably from the subform Current event. Not sure if that event will fire before the main form loads the first time or not. If it does, then it will probably error.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

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

Similar Threads

  1. Form, Combo box value display
    By Chair in forum Access
    Replies: 2
    Last Post: 06-08-2016, 07:24 AM
  2. Replies: 2
    Last Post: 07-08-2015, 12:14 PM
  3. Replies: 2
    Last Post: 06-10-2013, 06:22 PM
  4. Replies: 2
    Last Post: 04-04-2013, 05:56 PM
  5. Combo Box Display in Form
    By rachello89 in forum Forms
    Replies: 2
    Last Post: 05-11-2012, 05:44 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