How to get a subform to update

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

Guest

I have a main form called "Daily Dispatch Log" this form contains three
subforms. Now two forms Vessel Activity and Officer Log On, these forms
control what I refer to as Vessel or Officer Status Subforms. When I add a
new record or make changes it shows on the Subforms, however when I take them
out of service the form will not refresh. I am using a check box to take
them out of service. Any suggestions out there? I guess I am looking for
one code to continuously resfresh my data when I close a form to update the
subform but the refresh command is not working....

Thanks in advance...Jen
 
I have a main form called "Daily Dispatch Log" this form contains three
subforms. Now two forms Vessel Activity and Officer Log On, these forms
control what I refer to as Vessel or Officer Status Subforms. When I add a
new record or make changes it shows on the Subforms, however when I take them
out of service the form will not refresh. I am using a check box to take
them out of service. Any suggestions out there? I guess I am looking for
one code to continuously resfresh my data when I close a form to update the
subform but the refresh command is not working....
Click to expand...

Use Requery (rather than Refresh, which just checks for changes made
by OTHER users) in the AfterUpdate event of the checkbox.

John W. Vinson[MVP]
 
John I was reading a little more in detail and I think I might know what the
problem is but I need help overcoming it.

Vessel Activity Screen is generated by a query from the Vessel Table
Officer Log On Screen is generated by a query from the Log On Table

Both forms are listed as a SubForm on a third Form that is generated by
Daily Dispatch Log Table.

So the question is how do you query a subform from another table to
automatically update when displayed as a subform in a different table?

I have tried to Requery, Refresh, AfterUpdate, AfterInsert,etc....

Thanks Jennifer
 
Back
Top