Subform Requery

[MTSPEER]

Hello,

I want to refresh my subform so once my table gets updated in my database it will automatically diplay the results as soon as I run my query where the table gets updated. I hate having to exit the database and opening it up again for it to be displayed. My Mainforms name is "Validation Tool" and my subform name is "Error_Sheet_subform.

Thank you

[amrut]

You do not have to exit the database, close and re-open the form. Better option, use following line of code in an a"appropriate" event. Or add button to the main form and put this line in it's click event. You may even run the update query and use the code to display the results in same event.

Me.Error_Sheet_subform.Requery