Refresh Forms that are already open

[samjh]

Hi,

I have forms that show commitments by Client, by Cost Centre, by Provider etc.

If I add new commitments or edit commitments it is done through the Commitments by Client form, as all other forms lead back to this one.

To create a new or edit an existing commitment, it is done through a Commitment Form, which goes into a query (query A)which does all the calculations. My client form has subforms based on Query A, however my other forms (commitments by Cost Centre etc) have subforms which have querys that are based on Query A . I hope that made sense.

My problem is that If I edit a commitment, the client form and subforms refrlect the changes imediately, even though they are open and I can see them changing when I change the commitments. However the other ones don't unless I close them and re-open them.

My navigation within the database is based on once a form has been opened it is set to be invisible untill called on again (i.e. visible = False).

Can anyone tell me how to requery all the forms without having to close them.

Thanks.