hi
I have a uerform with combo/textboxes and listbox ,if there is only one item listed it does not show in listbox although it does in textboxes,and does not pull image up in imagebox ,have added another item to the list and now it brings it up as should do,in combobox enter cooling towers,have left this second entry in,any ideas please have tried changing listbox to 1 and 0 but nothing seems to do it
cheers colin
Last edited by cfinch100; 08-19-2013 at 10:34 AM.
Colin
How do we get only one item to appear?
Coooling Towers returns 2 instances.
If posting code please use code tags, see here.
hi norie
if you go to sheet1 and delete the second entry,just says cooling towers and no other info and then try again,hopefully it will show you what I mean
it does not populate listbox with only one entry
cheers colin
Your code doesn't populate the listbox unless f > 1. If you want to populate anyway, I don't know why you bother with the test for f - simply call FindAll regardless.
Remember what the dormouse said
Feed your head
Colin
I think this might be a problem.
When you step through the code f is 1 when only one instance is found so the cmdFind_Click sub will just end basically.
Please Login or Register to view this content.
Try changing 1 to 0.
hi all
thanks very much,it was the problem ,have changed it to o and works well many thanks again
cheers colin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks