How to write to a dao.reocrdset2 multi-select/ list field

[pdxrichard]

I see examples of how to read a list field but no example of how to write to one. I am taking an excel spreadsheet and importing it with code but one of my table fields is a list select field and the online example only shows how to read a field but not write to it. Can anyone give me an example of how to write to such a field? This is the link I am referencing: https://docs.microsoft.com/en-us/off...XAJwpzC2nK_7ek



In my code I thought I could simply look up the matching option from the option table and then record the value to the list field called "StyleOpt". But of course this doesn't work.


'//Lookup styles first in the style table and then save the ID to the table
'Dim rsSTY As DAO.Recordset2
'Dim fldSTY As DAO.Field2
'
'Set fldSTY = rsWIP("Style") <--- this is the list field
'
' Set rsSTY = modDB.DBWOP.OpenRecordset("SELECT * FROM tblWIPStyleOpt WHERE (([StyleOpt] = """ & xlSheet.Cells(i, 6).Value & """))", dbOpenDynaset)
'
' Select Case (rsSTY.EOF)
' Case False: rsWIP![Style] = rsSTY![StyleOpt]
' Case Else: rsWIP![Style] = Null
' End Select
'
' rsSTY.Close
' Set rsSTY = Nothing

[orange]

Most readers with Access experience would advise you to avoid multi-valued fields.
I suggest you describe to us in 3-4 lines of simple English what you are trying to accomplish.
Once readers understand What, you will get more focused advice on How to do it with Access.

As for multiselect listbox, you may get some insight from this link.
Good luck with your project.

[June7]

See if this helps https://support.office.com/en-us/art...624e1e323a#bm7

I agree, multi-value fields are an aggravation, I never use.