Kalyan Ganesan
Programmer
The recordset type i have is Dynaset (Inconsistent Updates)
I am updating the recordset in runtime thru below code
Dim strSelect As String
Dim rs1 As DAO.Recordset
strSelect = "SELECT * FROM MAIN"
Set rs1 = CurrentDb.OpenRecordset(strSelect)
Set Me![subform].Recordset = rs1
Set rs1 = Nothing
it works but the controls in the subform become non editable, if i dont update the recordset in runtime and use LinkedMasterfields then the controls are editable
what property do i need to set to make the form editable
I am attaching the property sheet of the subform in the image
I am updating the recordset in runtime thru below code
Dim strSelect As String
Dim rs1 As DAO.Recordset
strSelect = "SELECT * FROM MAIN"
Set rs1 = CurrentDb.OpenRecordset(strSelect)
Set Me![subform].Recordset = rs1
Set rs1 = Nothing
it works but the controls in the subform become non editable, if i dont update the recordset in runtime and use LinkedMasterfields then the controls are editable
what property do i need to set to make the form editable
I am attaching the property sheet of the subform in the image