Subform Refreshing!

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.
 
G

ghetto_banjo

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
 

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