Need help with Sales invoice

[Ahmed Fawad]

I've got a Sales Invoice form, I want to take all details when I enter an old invoice number, I know it's very plain n simple but the error it's showing I'm not getting it resolved. Form n VBA code is there.

Same code I'm using on Vehicle reg. # to get all the details if already in the record, it's working perfectly.

The error is "Unable to get the VLookup property of the WorksheetFunction class"

Code is

Private Sub txtinv_AfterUpdate()

    
    With Me
    
        cmbsflock = Application.WorksheetFunction.VLookup(Me.txtinv, Worksheets("SALES").Range("B:K"), 2, 0)
        
        txtsdate = Application.WorksheetFunction.VLookup(Me.txtinv, Worksheets("SALES").Range("B:K"), 3, 0)
        
        txtvreg = Application.WorksheetFunction.VLookup(Me.txtinv, Worksheets("SALES").Range("B:K"), 4, 0)
        
        txtdname = Application.WorksheetFunction.VLookup(Me.txtvreg, Worksheets("SALES").Range("B:K"), 5, 0)
        
        txtmob = Application.WorksheetFunction.VLookup(Me.txtinv, Worksheets("SALES").Range("B:K"), 6, 0)
        
        txtpartyn = Application.WorksheetFunction.VLookup(Me.txtinv, Worksheets("SALES").Range("B:K"), 7, 0)
        
        txtdealern = Application.WorksheetFunction.VLookup(Me.txtinv, Worksheets("SALES").Range("B:K"), 8, 0)
        
        txt1w = Application.WorksheetFunction.VLookup(Me.txtinv, Worksheets("SALES").Range("B:K"), 9, 0)
        
        txt2w = Application.WorksheetFunction.VLookup(Me.txtinv, Worksheets("SALES").Range("B:K"), 10, 0)
        
    End With
    
End Sub

Please advise, TIA

Ahmed

 

[Gokhan Aycan]

Are there any empty cells in the vlookup range by chance?

By the way, code is inside "With Me" but no reference to it otherwise. Are the variables (left part) control names?

 

[Ahmed Fawad]

Are there any empty cells in the vlookup range by chance?

By the way, code is inside "With Me" but no reference to it otherwise. Are the variables (left part) control names?

Thanks for the replay, yes some empty cells are there.

 

[Ahmed Fawad]

Thanks for the replay, yes some empty cells are there.

Moreover, not in Column B but other details YES

 

[Gokhan Aycan]

Is it possible you enter a non existant inv number?

Have a look at StackOverflow

 

[Ahmed Fawad]

Is it possible you enter a non existant inv number?

Have a look at StackOverflow

Yes Non-existant will go for the new record, and formula will bypass by On Error Resume Next