K
Kevin
I am using the code to bind an ADO record set from an SQL db:
Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
'Use the ADO connection that Access uses
Set cn = CurrentProject.AccessConnection
'Create an instance of the ADO Recordset class, and
'set its properties
Set rs = New ADODB.Recordset
With rs
Set .ActiveConnection = cn
.Source = " Select ServiceRequestNumber, ServiceRequestName,
TaxonomyID, ProgramID, Capitalizable, CarryOver, Comment From
dbo.SR_Master_Data Where UpdateNeeded = 1"
.LockType = adLockOptimistic
.CursorType = adOpenKeyset
.CursorLocation = adUseClient
.Open
End With
'Set the form's Recordset property to the ADO recordset
Set Me.Recordset = rs
I can not update any of the data fileds on the form.
Any ideas?
Thanks Kevin
Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
'Use the ADO connection that Access uses
Set cn = CurrentProject.AccessConnection
'Create an instance of the ADO Recordset class, and
'set its properties
Set rs = New ADODB.Recordset
With rs
Set .ActiveConnection = cn
.Source = " Select ServiceRequestNumber, ServiceRequestName,
TaxonomyID, ProgramID, Capitalizable, CarryOver, Comment From
dbo.SR_Master_Data Where UpdateNeeded = 1"
.LockType = adLockOptimistic
.CursorType = adOpenKeyset
.CursorLocation = adUseClient
.Open
End With
'Set the form's Recordset property to the ADO recordset
Set Me.Recordset = rs
I can not update any of the data fileds on the form.
Any ideas?
Thanks Kevin