Subform new record

J

jeremy0028

on a main form lets call it sample1 i have a combo box called patient
account
I also i have command button add new record.

on the subform i have the following fields in datasheet view.


DOS Procedure Modifer Fee Pt Pmnt
07/05/05 71010.26 59 56.00 0.00

Example. i recieve payment from a patient

I select patient account from the main form which displays dos in the
subform

Patient made a partial payment for date of service 07/05/05 so i would
enter it like this

DOS Procedure Modifer Fee Pt Pmnt
07/05/05 71010.26 59 56.00 35.00

I recieve another payment for patient for the same date of service
I select patient account on the main form click new payment

But in the subform stills displays like this

DOS Procedure Modifer Fee Pt Pmnt
07/05/05 71010.26 59 56.00 35.00

Is there any way that when i click the new payment the above will show
like this

DOS Procedure Modifer Fee Pt Pmnt
07/05/05 71010.26 59 56.00 0.00
 
R

Rainbow01

need requery your subform

in the suitable event use:
assume your subform name is "PatientAccountSub"
Me.PatientAccountSub.Requery


"(e-mail address removed)" 來函:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top