Macro help - Refresh

[joolsUK0575]

Hi there

I have two forms in a database. One is the main form the other a sub-form.

On the subform I am running an append query.

My problem is this. Once the query has been run I have to come out of the record and back in again to see the appended data.

Can you tell me if there is anyway or anything that can be written in to a macro to refresh the data. I have tried the RunCommand but this does not seem to work.

Any ideas?

Thanks

Jools

 

[paul.raeburn]

Refresh

Try to use the requery action within your macro, or write in code to refresh the subform.

 

[wazz]

You could close the form and reopen it to the same record by saving (setvalue) the record number to a hidden txtbox on a hidden form and then calling it from the macro to get back to the record again.

i know this doesn't really answer your question, but just in case this helps...................