Why is Form not Edit-able

[FinalPrime]

The Form allows no edits if I populate like so:
Private Sub Form_Load()
Set r = New ADODB.Recordset
With r
.ActiveConnection = CurrentProject.Connection
.CursorLocation = adUseClient
.CursorType = adOpenDynamic
.LockType = adLockOptimistic
.Source = "SELECT * FROM tblTrans "
.Open
End With
Set Me.Recordset = r
End Sub
+++++++++++++
Why does the Form not allow updates? Full rights
are with the Form. When the Form is bound
to tblTrans, updates are allowed.

any help / insight will be appreciated.
Final Prime

 

[RoyVidar]

Hi!

Hi I'm assuming you are using access 2000.

What I've read, forms recordset are DAO in all versions up to xp (don't know about 2003 - the exeption being ADP (access projects))

Funny thing, before posting, I tested your excact code on both xp and 2000.

In xp it worked, I was able to do updates, and retrieve a forms recordset.clone as ADO.

In 2000 I'm getting the same results as you.

Perhaps consider DAO if bound form isn't appliccable?

HTH Roy-Vidar