MangroBongacello
Programmer
Hi,
this is driving me nuts. I have a bound datagrid. The record source is a query with 4 tables included. User should be allowed to change data in some fields (all from only one of those 4 tables). At first, I got error message saying Insufficient key information for updating or refreshing. This was strange since I got the primary key of the table whose data is to be changed included in the query. Then I found somewhere a suggestion to set the Unique table property of the recordset. So I did that:
recordset.properties("Unique table"
="TableName"
but now I get another error message saying Unique table is nonexistent or not completely specified. Any suggestions?
Thank you, Mangro
this is driving me nuts. I have a bound datagrid. The record source is a query with 4 tables included. User should be allowed to change data in some fields (all from only one of those 4 tables). At first, I got error message saying Insufficient key information for updating or refreshing. This was strange since I got the primary key of the table whose data is to be changed included in the query. Then I found somewhere a suggestion to set the Unique table property of the recordset. So I did that:
recordset.properties("Unique table"
but now I get another error message saying Unique table is nonexistent or not completely specified. Any suggestions?
Thank you, Mangro