Re: [MS_AccessPros] Form Collection Voucher Recordset not updateable

 

Khalid-

Where is Rate defined?  It's not in the Record Source.  The Record Source appears to be updatable.

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 9:28 AM, Khalid Tanweer khalidtanweerburrah@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

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: John Viescas <johnv@msn.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (4)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___