Solved: Database search returns the same values for all parts chosen

[Mbierce]

Hello all!

So, I've never really used VBA before but figured I'd try my hand at creating a database for work and used some websites and Youtube videos to guide me to create the tool. However, I'm having an issue where all parts that are searched return the same values. When opening the file, the user is given buttons to choose from. Right now the only two buttons are Infeed Conveyor Parts and Exit. When choosing Infeed Conveyor Parts, the user is then able to search for a part by description to get details on that part as well as the Oracle number and quantity needed. However, the way that I have this set up I can only get the values for Conveyor Length to return. (This happens regardless of what I choose.)

Any guidance would be appreciated!

Edit: I apologize for the not following rule #1. Thank you for pointing it out to me protonLeah. Hopefully I've fixed it sufficiently.

[protonLeah]

title updated

[BadlySpelledBuoy]

Hi,

Could you explain a little about what you want it to do if it's working properly?

If you click on "New" you want to add entered details to the bottom of the list?

What if you're searching for an item and there are more than one in the list? "Return Roller Cat Roller (Bolts)" for example is in there twice, so what happens in that situation?

BSB

[Mbierce]

Hello all,

I think I've fixed the rule violation and posted the subject line accordingly.

BadlySpelledBuoy, thank you for pointing out that items are listed multiple times. I didn't catch that before and am have changed this on my end. It did not change the search issue though.

[protonLeah]

Please Login or Register  to view this content.

[Mbierce]

Thank you for your help! This solved the issue.