I have completed a database using this seminar and it was working perfectly until I put the tables on SharePoint. Now on the ClientF form when I click on the "Add New Loan" button I get an error "Invalid use of Null". Why is it giving me this error? when I click on debug it takes me to this vba code and points to the 7th line (X = Forms!LoanF!LoanID)

Private Sub Command5_Click()

    Dim X As Long

    DoCmd.Echo False, "Opening..."
    DoCmd.OpenForm "LoanF", , , , acFormAdd
    Forms!LoanF!LoanAmount = 1
    'Forms!LoanF!Description = "NEW LOAN"
    X = Forms!LoanF!LoanID
    DoCmd.Close acForm, "LoanF", acSaveYes
    DoCmd.OpenForm "LoanF", , , "LoanID=" & X
    DoCmd.Echo True
    
End Sub

I am not sure if this is the right place to submit my question or if it should be done on TechHelp. I am in a big pinch at the moment with this problem and have been unable to find a solution. I really hope you can help me with this and if this isn't the correct place to post this please direct me to the correct place to get the fastest response. Thanks, Maryann

---

Reply from Alex Hedley:

Are you using a Sharepoint List as a Table?