var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Edit record using VBA
I am not sure whether you all have checked my previous message, I posted again. Thanks. I tried to edit the record. It didn't work. could you please check my code for me?
I think the line of code: Set rstTableE = dbs.OpenRecordset(strSelect)
caused the stop to edit.
Dim dbsE As DAO.Database
Set dbsE = CurrentDb
Dim rstTableE As DAO.Recordset
Dim strSelect As String
strSelect = "Select * from tblReceipt where ReceiptNumber = " & txtReceiptNumber
Set rstTableE = dbs.OpenRecordset(strSelect)
!ReceiptDate = Me.txtReceiptDate
!Fund = Me.cboFund.Value
!Category = Me.lstCategory.Value
!ReceivedFromFName = Me.txtReceivedFromFName
!ReceivedFromLName = Me.txtReceivedFromLName
!Company = Me.txtCompany
!Country = Me.txtCountry
!Memo = Me.tMemo
Try not to double post please yyu.
Let's continue this on the original thread.
Me.Geek = True