Re: [MS_AccessPros] Form Collection Voucher Recordset not updateable

 

John,

Record Source of Form is query:

SELECT [Consignment Number].ConsignmentNo, [Consignment Number].ExportDocs

FROM [Consignment Number]

ORDER BY [Consignment Number].ConsignmentNo;

Khalid

On Monday, November 3, 2014 1:07 PM, "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:

 

Khalid-

What is the Record Source of the form?  The SQL, please, if it is a query.  

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

SQL Queries for Mere Mortals 

http://www.viescas.com/ 

(Paris, France)

On Nov 3, 2014, at 8:50 AM, Khalid Tanweer khalidtanweerburrah@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

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 (3)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___