Normal Topic Subform. (Read 579 times)
drastixnz
Full Member
***
Offline


A Newbie....

Posts: 146
Location: New Zealand
Joined: Nov 29th, 2006
Subform.
Nov 7th, 2007 at 11:06pm
Print Post Print Post  
I have a subform, that has an balance on it, and I am wanting to be able to add a payment line, which then will deduct from the balance and give me a new total.

how? can anyone point in the right direction.
  
Back to top
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Subform.
Reply #1 - Nov 8th, 2007 at 4:40am
Print Post Print Post  
On the form, need three elements: Beginning Balance, Payment, Ending Balance
Make Ending Balance ReadOnly.
If the Beginning Balance is imported, posted in, or calculated vs. manual data entry, then make the Beginning Balance ReadOnly also.

Put formula in Payment element, On Element Change
Ending Balance = Beginning Balance - Payment

------------------------
This seems basic to me, but perhaps I am not understanding the question.  Not sure by what you mean that you want to add a Payment line.  This added a Payment element.  Do you need to add a subform to the existing subform?  Or perhaps you want the ending balance to be on the Parent Form?

As a general concept, I try to make most elements ReadOnly that are the result of anything except manual entry.  That is to prevent accidental changing of something that may have been the result of other actions. 
I also make KeyID fields ReadOnly if not @ISNEW.  Prevents seeing Key.. values in that element when someone thinks they are on the Retrieve Screen and replaces original KeyID value.



  



Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
IP Logged
 
drastixnz
Full Member
***
Offline


A Newbie....

Posts: 146
Location: New Zealand
Joined: Nov 29th, 2006
Re: Subform.
Reply #2 - Nov 14th, 2007 at 8:51pm
Print Post Print Post  
Hi all, sorry for not making myself clear.

I have a subform, which is in table view, the last LE is called Balance.

When a invoice is made it populates the balance field with the total which creates a record (say record number 1) in the LE. which is right.

The problem is when I add a payment, it creates another record (Record Number 2) in the subform, but i dont know how to take the balance from record number one, to record number two.

Regards drastixnz
  
Back to top
IP Logged
 
drastixnz
Full Member
***
Offline


A Newbie....

Posts: 146
Location: New Zealand
Joined: Nov 29th, 2006
Re: Subform.
Reply #3 - Nov 20th, 2007 at 9:56pm
Print Post Print Post  
After doing some reading i have change it so it will pop up an window with the transactions on it
  
Back to top
IP Logged