Calvin Freeman
New member
- Local time
- Today, 05:07
- Joined
- May 26, 2020
- Messages
- 3
I know that this is going to be simple for someone that knows the Syntax but here goes.
I have a table called "mortgagepayments". When I enter the Subform, called mortgagepayments3, I call up the last record and would like to hold the value of a field called mort_currentbal.
Then call up a new record. In the new record I would like to input the value that I am holding into a field called mort_previousbal. I've tried the code several different ways but it always errors.
My latest code is
Private Sub mortgage_payments_part3_Enter()
Dim balance As Currency
RunCommand acCmdRecordsGoToLast
SELECT [mortgagepayments.mort_currentbal] as balance From CurrentRecord
RunCommand acCmdRecordsGoToNew
INPUT [mort.previousbal] = balance
End Sub
I have a table called "mortgagepayments". When I enter the Subform, called mortgagepayments3, I call up the last record and would like to hold the value of a field called mort_currentbal.
Then call up a new record. In the new record I would like to input the value that I am holding into a field called mort_previousbal. I've tried the code several different ways but it always errors.
My latest code is
Private Sub mortgage_payments_part3_Enter()
Dim balance As Currency
RunCommand acCmdRecordsGoToLast
SELECT [mortgagepayments.mort_currentbal] as balance From CurrentRecord
RunCommand acCmdRecordsGoToNew
INPUT [mort.previousbal] = balance
End Sub