Subform new record

  • Thread starter Thread starter jeremy0028
  • Start date Start date
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
 
need requery your subform

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


"(e-mail address removed)" 來函：
 
Back
Top