Problem with listview click event.

[Kiran2012]

Hi,

I have a userform in which user can select multiple criteria and the final result is displayed in a Listview. Everything is working fine. I use Access as the database. For some records, some fields are blank. For that 'Not Available' is displayed.
Problem is when the select criteria returns a record which having all the fields as 'Not Available' (which is displaying correctly in Listview), when user clicks on this item i'm getting error message 'Run Time Error 13 Type Mismatch'. Only the first field is in 'Number' data type. Completed my project almost but unable to submit due to this error. Below is my code:

Please Login or Register  to view this content.

Kindly have a look and plz help me out. Thanks in advance.

[JosephP]

which line causes the error?

[Kiran2012]

If Me.ListView1.SelectedItem >= 0 Then

in the listview click event

[JosephP]

perhaps just change it to

Please Login or Register  to view this content.

[Kiran2012]

Hi JosephP,

Its working.
Thanks a ton.

Regards,
Kiran2012

[JosephP]

you're welcome

If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save