I have this code and I am getting the above error msg (Err.Num 35603)
rs!Memb_ID.Value is the primary key in the database.Code:Do While Not rs.EOF Set lvwItem = lvwMain.ListItems.Add(, rs!Memb_ID.Value, rs!First_Name.Value & " " & _ IIf(rs!Middle_Name.Value = "", rs!Surname.Value, rs!Middle_Name.Value & " " & _ rs!Surname.Value)) rs.MoveNext Loop
Can't you use this?




Reply With Quote