Add new record

[jeremy0028]

I have a table and form called add charge it has the following

Patient Acount
Date of Service From
Date of Service To
Procedure
Modifer
Fee

I created a append query using the add charge fields in the following
manner
This appends information in payments see below

patient account
Date of Service From
Date of Service To
Procedure
Modifer
Fee



Ok i have a table lets call it Payments. On that table i have the
following

patient account
Date of Service from
Date of Service to
Procedure
Modifer
Fee
Insurance Payment
Patient Payment
Copay
Balence

I have a form called form1 on that form it has patient Account as a
combo box
I also have a subform call form 2 this Has

Date of Service from
Date of Service to
Procedure
Modifer
Fee
Insurance Payment
Patient Payment
Copay
Balence

Which is in datasheet view

On the main form I have a command button called new payment which add
a payment into the
database however when i click the command button just add a blank row
under the fields

Example
I press new payment command button
I select Patient account
On the subform displays open dates of service
07/05/2005 Fee 56.00
07/06/2005 Fee 100.00

I enter lets say $35.00 for date 07/05/2005 in the insurance payment
field
I recieve another payment for the same date for 20.00 when i hit enter
new payment
select the patient account still displays $35.00 in the insurance
payment field
Also it adds a new blank row which i dont want to happen.

What i want to happen is when i click new payment in the following
fields will display 0.00 so i could enter a new payment without the
previous payment still being there

Insurance payment 0.00
Patient Payment 0.00
Copay 0.00

Please be speciific because i'm a newbie

Any ideas.

 

[Guest]

If you want to combine the payments, you do not want to add new records, you
want to edit the existing record where the other payment was recorded;
however, I would suggest this is not the correct thing to do. Have done a
bunch of accounting systems, I kind of have an idea of how this should work.
The problem is that if you have to ever research when and how much a payment
was made, you have no way of determining that. It is much better to enter a
new row in your table for each payment. If you want to see the total of all
payments, you can accumulate them with a query.