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
 

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

Similar Threads

subform based on external SQL won't requery 1
refresh/requery subform 2
requery continuour subform 11
Recordcount is always 1 step behind. 1
subform total 5
requery not working 7
requery subform 2
Requery Subform ComboBox from Other Form 3

Back
Top