Display relevant information from excel sheet into form

  • Thread starter Thread starter dave
  • Start date Start date
D

dave

Hello guys,

I need a help here. I have created little database in excel for stock
control which included few forms. Now what im trying to do is when
enter part number in text box and click the search button, I want all
the parts and all the related information for the part to be display
in the text box or label in the form. Some part I have more that one,
I need need all to be display below the search box where I have places
a large text box so it can display more than one item. Please help
with the VBA code

Thank you

dave
 
Hello guys,

I need a help here. I have created little database in excel for stock
control which included few forms. Now what im trying to do is when
enter part number in text box and click the search button, I want all
the parts and all the related information for the part to be display
in the text box or label in the form. Some part I have more that one,
I need need all to be display below the search box where I have places
a large text box so it can display more than one item. Please help
with the VBA code

Thank you

dave
Click to expand...
Sounds like a drop down with avail part numbers tied to a worksheet
change event macro to simply goto the database and filter for the part
#. Send me your file if you can't figure it out. dguillett1 @gmail.com
 
Sounds like a drop down with avail part numbers tied to a worksheet
change event macro to simply goto the database and filter for the part
#. Send me your file if you can't figure it out. dguillett1 @gmail.com
Click to expand...

Hi,

I have sent the file to your gmail as advised. Thanks again
 
Sounds like a drop down with avail part numbers tied to a worksheet
change event macro to simply goto the database and filter for the part
#. Send me your file if you can't figure it out. dguillett1 @gmail.com
Click to expand...

Hi Don,

Have you got my email. I have sent the file and awaiting for updates.
Please advise.

dave
 
Back
Top