Refresh Forms 1

[logopolis]

I have a form which has a subform and that subform has a subform. There are fields in the parent from which come from a query which is made up of fields from a couple of these forms. I have a refresh button on the form but it is not refeshing the data from the query, which only changes once I have shut down the form and then reopened it. Is there any way to make this refresh the data more easily?

 

[cghoga]

Have you looked at the requery function? You might try reinitializing the RecordSource.

 

[logopolis]

I have never used that before, can you tell me more about it

 

[logopolis]

Its ok I found it, really useful, thank you very much