Update SubForm Data

[karl009]

Hi,

I have a form which has a subform, on the form there is a button where a user can open a form to enter data into the database, this data once in the database should be displayed on the subform but to update it I have to close the form down and reopen it.

How can this be updated when the form that enters the data closes?

Many Thanks

 

[pbaldy]

You can requery it:

Forms!FormName.SubformControlName.Requery

 

[karl009]

Hi,

Would this be on the form I enter my data as an After Update Event?

Thanks
Karl

 

[pbaldy]

Possibly, though from the original description I would opt for the close event of the other form (so the first form is requeried when you come back to it). Realistically, it can be done from anywhere, so you just need to pick the appropriate event for your situation.