Display relevant information from excel sheet into form

[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

 

[Don Guillett]

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

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

 

[dave]

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

Hi,

I have sent the file to your gmail as advised. Thanks again

 

[dave]

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

Hi Don,

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

dave