Add new Record Datasheet view subform

[jeremy0028]

I have a form lets call it table one. On that form it has a combo box called patient account. I Also have a form in datasheet view called lets table 2 which is the subform for table one form. On that form i have the following

Date of Service from
date of service to
procedure
modifer
fee
insurance payment
patient payment
copay
balence

I have a command button new payment which adds a record to the database.

I want to link this new payment command button to
the following fields in the datasheet view subform called table
Insurance payment
Patient Payment
copay

I tried this many ways but every time just adds a new row
which i dont want

Example i enter 35.00 in the insurance payment i click new payment the 35.00 is still there in the insurance payment field but just add a new row

any ideas

 

[TheAceMan1]

How are ya jeremy0028 . . .

Have a look at the [blue]Data Entry[/blue] property!

See Ya! . . . . . .

 

[jeremy0028]

What do u mean by data entry property can u be a little bit more specific i'm a newbie.