Hi all
I'm opening a recordset like this:
SQL$ = "Select " & strfields$ & " From "
SQL$ = SQL$ & tblname$
SQL$ = SQL$ & " a, CustomerContactPoint b where b.CustomerID
= "
SQL$ = SQL$ & RS2!CustomerID
SQL$ = SQL$ & " AND b.ContactPointType = '"
SQL$ = SQL$ & tblname$
SQL$ = SQL$ & "' AND b.ContactPointID = a.ContactPointID"
Set RS3 = DB.OpenRecordset(SQL$)
RS3.Updatable = True
I inserted the RS3.Updatable = True line because I was having
problems with the Recordset being read only when I invoked RS3.Edit.
Now it gives me an error saying "can't assign to read-only property".
Why is this recordSet read only? Any one? this is driving me nuts...
Ben