Userform search issue

Hello All,

I am tried to created a Search userform with a listbox but I am getting a 'Runtime error 1004' I have underlined the code below.

Has anyone got any ideas why this might be happening?

Many Thanks

Please Login or Register  to view this content.

Originally Posted by Norie

When you get the error what is the value in SearchColumn?

The value is "DrawingNumber"

A cleaner method employing filtering - no messy clunky additems
You can replace the comboboxes with textboxes if you wish.
torachan.

Originally Posted by Norie

Is there definitely a column with the exact name 'DrawingNumber' in a table with the exact name 'Table5'?

Okay I have checked and now only DrawingNumber column appears to be working, Iam not getting any results in any other column?

Originally Posted by torachan

A cleaner method employing filtering - no messy clunky additems
You can replace the comboboxes with textboxes if you wish.
torachan.

I would like to stick to my eaxmple if possible because I would like to be able to delete search results from the list box eventually

Originally Posted by Norie

You are missing the End If for the DrawingNumber If but you seemed to have added an 'extra' End If' at the bottom of the code and that's allowed the code to compile.

Thanks for that, Only issue is now I only appear to have 4 columns within the listbox? See screenshot

Attachment 708151

Also what would be the best way to add a delete function?

Originally Posted by Norie

I'm afraid the attachment didn't work.

Had a look at the file though and you've set the column count of the listbox to 4 in it's properties and you don't appear to change that in the code.

Thanks for you Help all working now