what I am doing wrong in this query

[khan]

SELECT Products.Manufacturere, Products.ProductDescription,
Products.SerialNumber, Products.QtyOnHand, Products.Location
FROM Products
WHERE
(((Products.Manufacturere)=[forms]![frmProducts]![cboManufacturer]) AND
((Products.SerialNumber)=[forms]![frmProducts]![cboSerial]));

cboSerial and cboManufacturer are combobox on my frmProducts I want
when user select values in both combo box then he should be able to run
query in the base of both combo box vale. but its not doing any thing.
even I run only query it doesnot ask me for perameter.

[Allen Browne]

The query looks fine. What is the problem: it is returning no records at
all?

That could happen if:
a) Either of the combos is blank.

b) The Bound column of the combos does not match the fields in the query
(e.g. the combo is bound to a ManufacturerID, but the query is comparing the
Manufacturer's name.)

c) The combos are actually list boxes with Multi-select turned on. (They
will behave like nulls if you try that.)

d) Access misunderstands the data types of the 2 parameters. To avoid this
issue, declare the 2 parameters (Parameters on Query menu in query design),
and if the 2 fields are not Types, set the Format property of the combos on
the form.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"khan" <ah******@gmail.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...

SELECT Products.Manufacturere, Products.ProductDescription,
Products.SerialNumber, Products.QtyOnHand, Products.Location
FROM Products
WHERE
(((Products.Manufacturere)=[forms]![frmProducts]![cboManufacturer]) AND
((Products.SerialNumber)=[forms]![frmProducts]![cboSerial]));

cboSerial and cboManufacturer are combobox on my frmProducts I want
when user select values in both combo box then he should be able to run
query in the base of both combo box vale. but its not doing any thing.
even I run only query it doesnot ask me for perameter.

[khan]

thanks man