Compile Error: With AutoFill a Form

[jeran042]

Good afternoon all,

I am getting the following error message when using my combo box to auto fill some fields on my Access 2007 form, "Compile Error: method or data member not found. The cbobox has an embedded query behind it that pulls (correctly from 2 different tables) all the information I am looking for. The first 4 fields are pulled and filled correctly, when I added the fifth field (from a third table) I get the error message. below is the code that I am using:

Private Sub cboVendor_Number_Change()    Me.Vendor_Name = Me.cboVendor_Number.Column(1)
    Me.Assigned_To = Me.cboVendor_Number.Column(2)
    Me.Notes_tblVendor = Me.cboVendor_Number.Column(3)
    Me.Notes_tblVendor = Me.cboVendor_Number.Column(3)
    Me.AVAILABLE_SOURCES_tblEFT = Me.cboVendor_Number.Column(7)
End Sub

Not sure why "Me.Notes_tblVendor = Me.cboVendor_Number.Column(3)" works identifying the third column a second time in the query, but it works.

What Can I try? And is there a better way to go about this?

Thank you,

 

[ranman256]

it means you dont have 7 columns.
did you count correctly?
(remember vb count starts at zero. cbo.col(7) is the 8th column)

 

[jeran042]

No, the "Me.Vendor_Name = Me.cboVendor_Number.Column(1)" i actually the second column, the count is correct. Even the "Me.cboVendor_Number.Column(7)" returns the value I want in the field, but I am getting the error. I have tried error handling: on error goto 0 and on error resume next with no luck,

Thank you for the suggestion,

 

[Micron]

The data member that is not being found is probably Me.AVAILABLE_SOURCES_tblEFT
Check your spelling for the form control name.
For my own enlightenment, what is the reason for repeating the column 3 line?
If my suggestion is not correct, which part of the code line is being highlighted when the error is raised?