query problem

[colinmunnelly]

Hope someone can point me in the right direction.

I have linked an ecxel worksheet 'called COR log table' within this table is a list of documents each with a value attached. For example one may have a value of £100,00.00. Within the access database there are orders raised against the ' COR documents ' For example COR number 25 could have any number of orders against it. Each order raised has a value and i need a way of either warning the user or have a running total of the value of orders raised against the COR's as the total value of the orders should not exceed the value of the COR.

Hope this makes some sense!!!

Any help appreciated

 

[FoFa]

There are a number of ways to do this, I usually like the easiest to understand approach. Then 6 month or a year from now when you have to change it, you don't spend hours trying to refigure it out. That said, I would create a query that would sum all the values for a COR amount (pull the COR key from the form). Than when a user enters the form and chooses a COR, you can use a DLOOKUP against the query to pull the current amount charged aginst it.
Not the most effeciant, but easy to understand.

 

[colinmunnelly]

Thanks for your attention.
What i have at the moment is a form in which i have a combo box where i select a COR. It would be ideal to have a simple text box that displays if the amount (CMI amount) against that COR. i create a query that consisting of COR Number (group by) and COR Value (Sum of) correct? Am i right in thinking if i have a text box and have its control source my combo box (listing CORs) will that then select the correct value?