Requery

[Eddie Mason]

I have a form (FormA) which contains two sub forms the first sub form (SubFormB) has a command button that runs an action which modifies data in a table. The second sub form (SubFormC) is a dynaset that has as its record source the data that has been modified.

The command button works well and changes the data however, after it has been run, I cannot get it to requery the record source in SubFormC to show the new data. Is there any way of getting to do this?

Kind regards,

Eddie

 

[mh123]

Try;
forms![FormA]![SubFormC].Form.Requery
Or something along those lines!

Let me know if this works!

 

[JHB]

Try the below:

Me.Parent.[SubFormC].Form.Requery

 

[Eddie Mason]

Thank you very much for helping me with this problem it is now resolved.

Kind regards,

Eddie