Subform Refreshing!

  • Thread starter Thread starter Sqt_Squirrel
  • Start date Start date
S

Sqt_Squirrel

Can anyone offer guidance?

I have an unlinked form that contains two sub forms, the first subform lists
employees and the abs of their outstanding pieces of work, the second
displays a listing of the pieces of outstanding work for the employee
selected in the first subform.

From a On-Click action in the second subfrom the piece of outstanding work
can be navigated to directly and then editted show that it is not overdue;
however, upon returning to the form and subforms, the overdue work abs have
not updated and the piece of work still appears in the breakdown in the
second subfrom.

The form remains open throughout this proceedure; how can I force the data
in the form and associated subforms to refresh? I have tried combinations of
Requery and Refresh on the command button that switchs the DB to the form
inquestion but to no joy!!!!

All advice is greatly appricaiated!!!

Sgt.
 
put in a piece of code at the end of your on-click event (or you could
probably use the Activate Event as well) and put in the code:

me.SubformName.Requery
 
Back
Top