refreshing a form

[Steve]

Ok, I've looked in all my books and online and cannot
find the answer. I have a main form from which we can do
several things. There is a subform which shows aircraft
which are having maintenance to them. I can select an
aircraft and press the delete button to remove it but the
form still shows it as being there. In the past I have
programmed the form to close and then reopen but I feel
that I am ready to do something smarter. How can I do
this?

I really appreciate the people who volunteer their time
helping others. You all have been a tremendous help to
me.

 

[losmac]

For subform:
Form("Main")!subFormName.Requery
or
Form("Main").Controls("subFormName").Requery

When your program works in local network, use:
Form("Main")!subFormName.Requery
and
Form("Main")!subFormName.Refresh
to refresh records form network.