Allowed Credit Limit - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images Link Email

Allowed Credit Limit

Roger Strate

2 years ago

Hi Richard, I appreciate your video on getting a value from a subform and it was very helpful, thank you. I have an allowed credit limit box on my customer form and a Sum(ExtPrice) in the footer of the Order sub form. I would like to have the amount for each order reflected in the Order subfom reduce the credit limit number on the customer form after each transaction. Is there a way to do that? I am uploading images hopefully to make this more clear.

	Roger Strate OP 2 years ago

	Roger Strate OP 2 years ago

	Alex Hedley 2 years ago
CreditLimit - DSUM(of figures)

	Kevin Robertson 2 years ago
The screenshot below shows how I would do it. I have a second field showing the Available Credit. You don't want to change the Credit Limit itself.

	Kevin Robertson 2 years ago

	Roger Strate OP 2 years ago
I created two fields one for available credit using the DSum function and one called total orders. I followed your instructions for the IIF function it follows: =IIF ([TotalOrders]) = 0, [CreditLimit], [CreditLimit]-DSum("SumOrderTotal","CustomerOrderTotalQ","CustomerID=" & ([CustomerID]))). I get the error message "wrong number of arguments. Any ideas?

	Roger Strate OP 2 years ago
I like the IIF function for this field but I tried Alex' suggestion and it works great. Kevin thank you, if you figure out the IIF function for me I will use it. Thank you Alex as well.

	Kevin Robertson 2 years ago
You have an extra parenthesis after [TotalOrders]. `=IIF ([TotalOrders] = 0, [CreditLimit], [CreditLimit]-DSum("SumOrderTotal","CustomerOrderTotalQ","CustomerID=" & ([CustomerID])))`

	Richard Rost 2 years ago
Available Credit

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.