delete a value in a combo box

[xtrareal22]

Hello.i am doing a stock management system for a cafe.i have a stock,sales and reorder form.In my reorder form i have the primary key field as a comb box which displays a value based on a query that shows which items have to be reordered.So this combo box displays the item name


So for example Pepsi and coke need to be reordered.After i first select coke and reorder it first and save and then do Pepsi i want the combo box to not display coke but only Pepsi as coke has already been ordered.What should i do?

[orange]

You have to identify that Coke has been reordered. Then in your query you need to do something like this (concept only)

Select StockName from StockTable
WHERE StockQty < StockReorderLevel
and StockName NOT IN (Select stockName from ReorderTbl)

OR
If you indicate that Coke was reordered eg for Coke StockWasReOrdered = True then something like

SELECT Stockname from StockTable
Where StockQty <StockReorderLevel
And StockWasReOrdered = False


Once you reorder Coke, you have to do something to show that (many options for this I'm sure) and then your query has to use that info to bypass reorder of Coke.
Good luck.

[xtrareal22]

Okay so i created a query that checks and displays what has not been ordered.So on my reorder table,I have the reorder iD ,the stock ID which is a combo box whose values come from a query that shows the name of items to reorder to select from.when something is ordered and i click on a save button a dialog form opens to tell that the item has been ordered and i click okay.When i click OK i want the underlying row source query for the stock id field to change to the values from the items not ordered query.How can i do that?Is possible?

[orange]

Did you look at my response for some options?
https://www.accessforums.net/forms/s...index2.html#17

[xtrareal22]

I tried this query called item(s) not reordered.So like for an example coke and Pepsi are running low and not have been reordered,this two items dont show up in the query.But after i order coke first Pepsi is shown as not reordered in the query.What i want to do is for this query to show me those two item(s) have to be ordered before any of them is selected for reordering?

[orange]

???? In #4

Did you look at my response for some options?
https://www.accessforums.net/forms/su...index2.html#17

I gave a structure to show the concept involved. I don't know where you query fits. Did you adjust you table structure?
Can you post a copy of your database?

[xtrareal22]

i did something else and it works okay.Thank you for your time!!