Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2015
    Location
    new york
    Posts
    2

    Unanswered: Problem about struggling with an access form

    Hello everybody.
    I am struggling with an access form problem:

    I have a form includes List box "Mylist1" in access form. The control source for Mylist1 is a multivalued field in access table.
    Form is saving values from listbox to table successfully. I use dlookup vba command to open records again in form.
    After the records is opened I am using Update query to update all fields in table. But its not updating listbox "Mylist1".

    Can someone help me.

    I want to update Mylist1 from Form1 to multivalued field acc1 in access table1.
    Thanks!

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    you need to expressly refresh the underlying datasource for the lsit box
    after you have run the update query its soemthing like:-

    mylist1.refresh

    or

    mylist1.requery
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •