Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2015

    Unanswered: Update multivalued field from listbox in access form

    Hi Friends,

    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.


  2. #2
    Join Date
    Mar 2009
    Provided Answers: 14
    Multivalued fields are not standard database objects and they do not comply with the First Normal Form (see for instance: Therefore, you cannot use a query (written in SQL, the standard language to communicate with databases) to handle such columns (or "fields" in Access). You must use a DAO.Recordset2 object.
    Have a nice day!

Posting Permissions

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