Getting value from previous record

G

gator

I am using Form1 to enter records. Some of the records use different Receipt
numbers and some use the same Receipt numbers. When the user clicks a button
to enter a record into the Table1 with the values that are in textboxes on
Form1, I want to set a condition that says - if the previous record's Name
field (text value) in Table1 has the same text/value as the text/value of the
Name field on Form1....then use the previous record's text/value in the
Receipt field, otherwise, add (increment) 1 to the value of that Receipt
number. Below is the code I am currently using on the click event.

Private Sub cmdEnterRecord_Click()
Dim mycon As New ADODB.Connection
Dim ADOrs As New ADODB.Recordset
Set mycon = CurrentProject.Connection
ADOrs.Open "Deposits", mycon, adOpenKeyset, adLockOptimistic
ADOrs.AddNew
ADOrs!Source = Me.txtSource
ADOrs!Type = Me.txtType
ADOrs!FundID = Me.txtFundID
ADOrs!Account = Me.txtAccount
ADOrs!Date = Me.txtDate
ADOrs!ID = Nz(DMax("[ID]", "Deposits"), 0) + 1
ADOrs.Update
ADOrs.Close
mycon.Close
Me.TreasurerDeposits.Requery
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

RUN-TIME ERROR 2455 1
can't get validation to work 6
Passing listbox selected values to NEW table row 1
UPDATE Table with multiple textboxes 6
Export email from Outlook into Access... 3
trying to SUM rs in Textbox from criteria 1
Previous record value 3
How to set the default value to (previous value + 1)?? 1

Top