Requery control on subform when other form closes.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to make a control my subform requery. In the Form_Close section
of frmTransaction I have this code:

Forms!frmCustomers![Card Subform].Form.txtTotal.Requery

It seems as though it works, but the value on the subform does not change
until you move to a new record and then back to the record.

I have the subform based off a query that sums two different fields (Add and
Remove which are both numberical). Then on the subform I have a textbox
called txtTotal that =sumofadd-sumofremove. On Access 2002
 
Back
Top