none
refresh(??) pull down list help RRS feed

  • Question

  • I have a vendor table and a customer table. When adding products to the customer table, in a form, sometimes I have to add a new vendor. So I have a pop-up form for that. However, that vendor does not then show up in the pull down list for vendors on my customer form. How do I update that list without having to close the form and reopen it? 

    Please bear with me. I'm new to Access, have no idea how VB stuff works. Please, your explanations need to be clear, concise and simple.

    Thanks,

    Thursday, June 22, 2017 1:21 PM

All replies

  • Hi,

    After you close the new vendor form, try refreshing the dropdown list. For example,

    Me.ComboboxName.Requery

    Hope it helps...

    Thursday, June 22, 2017 2:34 PM
  • Hi sgallantan,

    Do you have any issue to implement the suggestion from .theDBguy?

    If you do, please feel free to let us know your current issue.

    If your issue has been resolved, I would suggest you mark the helpful reply as answer.

    Regards,

    Edward


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Monday, June 26, 2017 3:10 AM