469,927 Members | 1,664 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,927 developers. It's quick & easy.

what I am doing wrong in this query

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.

Nov 13 '05 #1
2 1119
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.

Nov 13 '05 #2
thanks man

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by spambox | last post: by
11 posts views Thread by Fernand St-Georges | last post: by
4 posts views Thread by =?Utf-8?B?VG9kZCBKYXNwZXJz?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.