SQL Statement to only pull information based on Text Box from a userform

OK,
I have a spreadsheet that prints receiving labels based on received purchase orders that pulls information from an SQL server. The problem is that it is pulling almost 40,000 lines of data to sort and pull at most 30 lines. One of steps is that the purchase order receipt register has a barcode that is scanned into a text box on a userform. Can I use this information to filter the SQL data pull to only grab that PO number? I'm at a loss on where to begin with this. Below is my SQL statement from the Query builder with an example of a PO number input(PO-rma100613).

Please Login or Register  to view this content.

Change your SQL to

Please Login or Register  to view this content.

I am editing the SQL Command under the query builder. Once the PO number is entered the query will run then recall the results. Based on Mr. Phillips response i'm now at this stage in the command. It isn't giving me errors which is a good step. txt_PO is the name of the text box in the form.

Please Login or Register  to view this content.

Ah hah! Got it. I just set up a separate peramenter. It's a work around, but does the job.

This site shows how to do it
http://superuser.com/questions/19745...rom-excel-2007

Please Login or Register  to view this content.

Originally Posted by welborns2

I am editing the SQL Command under the query builder. Once the PO number is entered the query will run then recall the results. Based on Mr. Phillips response i'm now at this stage in the command. It isn't giving me errors which is a good step. txt_PO is the name of the text box in the form.

Please Login or Register  to view this content.

That is not how I did it, I concatenated the textbox value into the SQL text.