i need to solve this problem within this week

[kegz]

Hi everyone, I'm totally new to access. I have my contribution table, expenses table and budget query. Now in my expenses form I want to see the budget of a certain budget category. for example the pastor budget so that I'm aware if my budget is running out.. What I did is I put a textbox in my form with the control source from a query. When I run the form the textbox will display #Name?. I really need help...

 

[Dhamdard]

Simply sourcing your textbox to any object works only of respective object is open in the back ground. If you don't want to have the object opened in the back ground use below expression in control source of the textbox:

=DLooku("[fieldname]","QueryName")

If you want to display a specific value do this:

 =DLookUp("[Fieldname]", "QueryName", _
      "[fieldnameoncurrentobject] = " & Forms![FormName]![FieldNameonreferredobject])

 

[kegz]

Thanks a lot.. I have another problem.. how can I update the budget? Ex. the budget for office supplies is php500.00 then I bought supplies for let's say php350.00 so the remaining budget will be php150.00 then the next day I bought supplies for php85.00, while the expenses is getting big the budget is running out.. is it possible without using vba code?

 

[Galaxiom]

The budget balance should not be stored because it is a derived value. It should be calculated as and when required by summing the expenditures and subtracting them from the full budget allocation.

 

[kegz]

ahhhm I'm new to access, can you give me some example Mr. Galaxiom?

 

[Dhamdard]

You should have a text box let's "Balance". This balance box should have an expression to sum up all expenditures and subtract the expenditure from the budget for the line-item such as

=[Fildnameofavailablebudget]-sum([fieldnameofexpenditures])

This will sum all expenditures and subtract it from the allocated/available budget.

 

[kegz]

Thank You it's a big help..