Am I just a moron or what?

[ChrisGow]

I have a form that has a combo box. When a value is selected in this combo box. My subform uses a query to get information based on what is selected in the combo box. There is no problem with getting this information.

The problem is that I need to be able to change one of the field values on the form so that I can make a table based on what I input.


This is confusing so I will explain what I am doing

I am trying to make a purchase order. I need to be shown my part number, description, On hand quantity, how many I need (calculated value). I also need a spot to enter an Order quantity ( this is the field I need to edit)


PLEASE HELP IM GOIN INSANE

 

[ScottGem]

First, unless a PO will always be for a single item, you really should have a transaction table to provide line items for the PO. This tranaaction table will be how you calculate on hand quantity as it should record ALL movement of product in or out.

If you want to automatically calculate the quantity to be ordered based on the on hand quantity and a minimum on hand amount, you can do that, then override the value if you want.

First you need to have a query that calculates the on hand amount. This would be a GroupBY query on the Transactions table grouped by partnumber that add all the Ins and subtracts all the Outs. You would then use a DLookup against this query to pull the Onhand amount for Part. You would compare that with your minimums to calculate the suggest order and assign that to your quantity control. You can then edit the suggested value.