Combo box Query no working

[Loc]

I have a combo box and the selection is from a table. I want to return the results to my Query but it's not working, in Criteria I have: [Forms]![PartsOrder]![PartAddCmbo]
From what I have found this should produce a result but when I run it I get no result in the Query. Is there a way I can see what information is going got this query?

[Bob Fitz]

Can you show us the SQL of the query and the SQL of the combo's Row Source property.

[orange]

As Bob has suggested, more info is required to help the reader with your real need.

Perhaps you could describe to us in plain English WHAT you are trying to do, and then seek options of HOW it may be done.
Seems you have told us more of HOW you have done something, and have not told us about the WHAT.

[Loc]

The combo box is in a from and in the footer, the form is used to place parts on order when the inventory level is lower then a set value (reorder point). So I have the form base on a query result. What I want the combo box to do, allow the user to add a part from the parts table to an order when the order does not meet the reorder criteria. I want to return the result of the combo box to the query and have the query update the part by checking a check box(Manual Order). In my reorder query I have the criteria were it looks to this information. Then it requerys and returns the result to the form so the user can enter a date and quantity. To make sure I am not crazy I tried to put this in its own form just to check if it's a problems with in the form I made and I get the same results. Here is the information you requested..

Query:
UPDATE Parts SET Parts.ManualOrder = Yes
WHERE (((Parts.PartNo)=[Forms]![PartsOrder]![PartAddCmbo]));

The combo box in the form does not have any SQL but here is the statement in Row Source Type
SELECT [Parts].[PartID], [Parts].[PartNo] FROM Parts;

The other querys work fine I checked the box my self and ran so that is not the problem. I have changed the type of query to a select just to see what type of result I am returning and I get no return back.

[Bob Fitz]

I think your problem is caused by the fact that your combo box has two columns (PartID and PartNo). You may only be seeing the "PartNo" value but when you make a selection you are actually selecting "PartID".
Instead of:
WHERE (((Parts.PartNo)=[Forms]![PartsOrder]![PartAddCmbo]));
Try:
WHERE (((Parts.PartID)=[Forms]![PartsOrder]![PartAddCmbo]));

[orange]

You may get some ideas from this data model or others at the databaseanswers.org website.
http://www.databaseanswers.org/data_..._mgt/index.htm

[Loc]

You got it Bob it works! I see it now some times when you look at things the answer is right there in front of you but you just don't see it.

Thanks a bunch, now to move on and make more problems..LOL

[Bob Fitz]

You're welcome. Glad we could help.