[MS_AccessPros] Form Collection Voucher Recordset not updateable

 

Hi All,

I have a Form "Collection Voucher" having sub form "CollectionVouchersubform", while data entry on the sub form's Header there is an unbound control "cmbSetRate". When i enter data on it an error message displays:

Run-time error '-2147352567 (80020009)':

This Recordset is not updateable

After clicking the Debug button, i see:

Private Sub cmbSetRate_AfterUpdate()

    If Not IsNull(Me.cmbSetRate) Then

        ' Apply a filter

        Me.Filter = "Rate = " & Me.cmbSetRate

        Me.FilterOn = True

    End If

    Rate = cmbRate   <--------------- ERROR COMING ON THIS LINE

    DoCmd.GoToRecord , , acNewRec

    CartonNo.SetFocus

End Sub

Need help please.

Khalid

 

__._,_.___

---

Posted by: Khalid Tanweer <khalidtanweerburrah@yahoo.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___