Missing LoanID - How To Build a Loan Amortization Database With Payment Schedules and Reports in Microsoft Access


	Back to Access Amortization Lessons Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Missing LoanID

Ian O

15 months ago

Loved seminar and your work in general.
However, since I have received a copy of the Amort2.1 I've received an error when I try to add a new loan.
The error is Run-time error 3075 Syntax (Missing Operator) in query expression 'LoanID='.

The Debug highlights this line in the

Details

Private Sub SetLifeOfLoanDates()
    LoanStartDate = Nz(DMin("DueDate", "ScheduleT", "LoanID=" & Forms!LoanF!LoanID), TempVars("MINDATE"))
End Sub

Can you help with a solution?

	Alex Hedley @Reply 15 months ago
Where did you try and create the Loan from? Which Form?

	Ian O'Dett OP @Reply 15 months ago
The Add New Button from ClientF

	Ian O'Dett OP @Reply 15 months ago
Alex, any thoughts?

	Alex Hedley @Reply 15 months ago
Does `LoanID` not auto populate when the Form opens?

	Ian O'Dett OP @Reply 15 months ago
I believe that is the issue. In particular, when the form opens as acFormAdd. I've even tested it by creating a new buitton with only the following. DoCmd.OpenForm "LoanF", , , , acFormAdd This creates the same error as the Add New button.

	Ian O'Dett OP @Reply 14 months ago
It seems as if the Form_Load function is firing before `Forms!LoanF!LoanAmount = 1` can be set

	Ian O'Dett OP @Reply 14 months ago
In particular, the SetDateFilters within the Form_Load function fires SetDateFilters which fires the SetLifeOfLoanDates function leading to the error mentioned in the beginning of this thread.

Ian O'Dett OP @Reply

14 months ago

I believe I have found a solution.  At least it seems to be working for me.  In the LoanF I did the following

Private Sub Form_Load()

    If Me.DataEntry = False Then
        LoanRequirementsOK
        TempVars("LoanConditionsChanged") = False
        SetDateFilters
    End If

End Sub

Hopefully, you find this helpful.  I look forward to any feedback you can provide.  Apologize for my delays in getting my response onto here.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Amortization Lessons.

Next Unseen

New Feature: Comment Live View