I am working on a inventory management system for a warehouse. I created a form to do so and a second form "Search Form" to conduct my searches, because there are multiple quantities of the same items on our shelves. I would like to double click on the desired row from the search results, in the list box and have it activate the corresponding row on the active worksheet. I am able to get it to fill in the text boxes on the user form, but when I try to update, delete or move it to my shipped tracker, it isn't synced to the correct row on the sheet.
Any suggests or ideas are Greatly Appreciated!!
V/R
Michael
Why do you have 8 different Case statements in ClearForm that do basically the same thing?
A simple solution to your issue would be to add the row number when you populate the results list (you can always hide that column if you want). You can then just use that directly in your DblClick event.
Velouria,
Thank you for your response. Can you give me an example of how to do this? i have tried and I have looked online to see if there is anyone else out there trying to do anything like what I am trying to do. I have been lost with this.
V/R
Michael
