How to get a subform to update

[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

 

[John Vinson]

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

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]

 

[Guest]

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