Combo box for parameter query

[AndeanWayne]

I have a parameter query where the input is through a form. One of the field is a simple Buyer Number. To make it easy for the client I want to select this from a combo box. When I choose thw buyer though it returns no records. The same buyer when I choose it through a text box gives me the correct 125 records. Here is my query entry: [Forms]![frmAA_TestParameters]![BuyerNumber2]. BuyerNumber2 is the combo box result. Any help is greatly appreciated.

 

[Mr. B]

Check the Bound column of your combo box to be sure that the correct value is being stored in the combo box. If your query is expecting a record ID numeric value and you are returning the string value of the name of the buyer that could be the problem.

 

[AndeanWayne]

The bound column of the combo box is text. If I direct the query to a text box it selects the buyer as entered. But the same buyer number in the combo box returns no records.

 

[Mr. B]

A combo box can have more than one field returned from the data source. The bound column is one specific column or field. What I was attempting to tell you is that if you want the Name to be used then you need to make that field to be the bound value of your combo box. If it was then the records would be being returned exactly like the text box.

If you want to post your database we can take a look and see.