Good Morning,
After opening my form when I tried to get the record to display, it produced following msg. This form has subform also which is apparently not working but that could be later on.
"You must use the dbSeeChanges option with OpenRecordset when accessing a sql server table that has an IDENTITY column"
and debugged on following main form code that placed on a combo to get record.
Set rst = CurrentDb.OpenRecordset("Select * from T_ProjectBaseContracts where ProjNum='" & CboSearchProj & "'")
Do anyone have idea about this and what is solution?
Can someone please help?
After opening my form when I tried to get the record to display, it produced following msg. This form has subform also which is apparently not working but that could be later on.
"You must use the dbSeeChanges option with OpenRecordset when accessing a sql server table that has an IDENTITY column"
and debugged on following main form code that placed on a combo to get record.
Set rst = CurrentDb.OpenRecordset("Select * from T_ProjectBaseContracts where ProjNum='" & CboSearchProj & "'")
Do anyone have idea about this and what is solution?
Can someone please help?