I cannot use DAO. This is MS ACCESS PROJECT .adp
I am trying to update some fields by pulling a record via ADO. I keep getting the
'object required' error. Here is my code:
Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Set cn = CurrentProject.AccessConnection
Set rs = New ADODB.Recordset
Set .ActiveConnection = cn
.Source = "SELECT * FROM jobs WHERE [SwiftTitle] = '" & Me.[cmbSwiftSelect1] & "'"
.LockType = adLockOptimistic
.CursorType = adOpenKeyset
Me.ReqPickupTime = rst.Fields("ReqPickupTime")
Set rs = Nothing
Set cn = Nothing
Does anything look wrong?