Column Property error

[oskar44]

When I run the following code I get on the line Me.txtID.Value = Me.ListBox21.Column(14) the error "Could not get the column property. Invalid argument". I have copied this code from a lesson I follow and revised to my needs. When I click to run, it copies the records to 15 text boxes I have on my userform and it works but then I get the error message. I have disabled all error lines so I can see where the error occurs. Where should I look for the column property?

Please Login or Register  to view this content.

[Arkadi]

I believe if you have 14 columns then they are numbered 0 to 13? This would explain why it errors on column 14

[oskar44]

Thanks for the help, I have 15 columns in my DB and 15 textboxes to get the data into. The code count starts at zero that's why the last line is 14 (14 plus the 0 value of the first txtLastName.Value gives total count of 15). Perhaps I'm wrong?

[Arkadi]

You are correct... any chance you can upload the file with the problem?

[oskar44]

Sure, here is the file but please note there are other problems in this file, its work in progress lol

[Arkadi]

Ok well checking the listbox in your file... it has 14 columns....
1. Lastname
2. Firstname
3. Company
4. Title
5. Work
6. Home
7. Fax
8. Mobile
9. Email
10. Address
11. City
12. State
13. Zip
14. Comments
Those numbers are the count... the column numbers are one lower of course.

[skywriter]

Sure, here is the file but please note there are other problems in this file, its work in progress lol

Your problem is the row source property for your list box doesn't include the column with ID.

You row source is:
MyDB!$T$9:$AG$152

It should be:
MyDB!$T$9:$AH$152

You also need to set your column count to 15 if you want to see the ID information in your list. Maybe you didn't want to see it and that's why you had it set to 14, but your problem is your row source only covers 14 columns.

[oskar44]

Excellent observation skywriter, thanks

[oskar44]

Sorry, forgot to say thanks to all for the help

[skywriter]

Excellent observation skywriter, thanks

Arkadi made it easy to figure out.

If you are happy with those who have helped you, please consider clicking the add reputation button in the lower left hand corner of where they have replied to your request for help.

[oskar44]

lol, easy for you but not for me