Text Box Parameter Query

[stapleford]

Hi Everyone,

I have created a pricing database to let me price specific items for specific customers. I have created a customer and and item table independant of each other. Right now i just want to return the Customer Name and the Item Number specified.

I have made a form that has a combo box to choose your customer and then i have made a few text boxes. I would look to be able to type in the item numbers in to these text boxes.

I have a made a query that allows me to search by customer and by item, but only for the first item. Once i add in the second text box criteria the query is returned blank.

This works:
Criteria:[Forms]![Price Lookup]![Text14]

qryPrice1Customer NameItem NumberDectron000016

This doesn't work:
Criteria: [Forms]![Price Lookup]![Text14] And [Forms]![Price Lookup]!
[Text16]


If anyone could provide some insight as to why this is occuring and how i could fix it, it would be greatly appreciated.

Thank you in advance,
Andrew

 

[pbaldy]

I suspect you want Or instead of And.

 

[stapleford]

Hi Paul,

I would like the query to ouput the all of the item numbers that were entered. For example if I decided to fill out three texts boxes with 3 different item number all for the same customer, I would like the query to output 3 lines with customer name and the corresponding item in the next column.

Thanks,
Andrew

 

[pbaldy]

Yes, I know. Did you try it? You may need this too:

http://access.mvps.org/access/queries/qry0001.htm

 

[stapleford]

I got it work, thank you for your assistance paul.

 

[pbaldy]

Happy to help Andrew.