Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Unbound form (1 minute it works the next it doesn't)

Status
Not open for further replies.

ceej

IS-IT--Management
Jun 20, 2001
46
US
I've been working on the form today. It worked earlier but now the recordset is not updateable.

I'm using AC2002 with ADO recordset.

Here's the code. If I use the table as a source it works, but I was using a recordset before and that was working too (not now).

Thanks for help!!

Dim cnn As ADODB.Connection
Set cnn = CurrentProject.AccessConnection

Dim rst As ADODB.Recordset
Set rst = New ADODB.Recordset

With rst
.CursorType = adOpenDynamic
.LockType = adLockBatchOptimistic
End With

rst.Open "TblInvHdr", cnn
Set Me.Recordset = rst

Set cnn = Nothing
Set rst = Nothing
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top