Refer to a Subform from another form

This took a while to figure out but Art Polk came to the rescue.

I had a popup form that when a button was pressed I needed to update the subform of the form which created the popup I was currently in. Basically, I used a popup to edit one of the records in a data grid. My objective was that once the update was processed the grid would refresh displaying the change…

Forms!frmParentFormName.Controls(“frmSubFormNeedingTheRefresh”).Form.Refresh

That’s it

Keith

Recent Content

Create A Single PDF File Per Record Report Using VBA & MS Access

This one was a tricky request. What I had was a recordset from a query in MS Access. I needed to create a report where when printed it would create one PDF file per record. MS Access has the...

Generate A List of Excel Sheets

Use this bit of VBA to create a list of Excel sheet name. - EASY Just add this code in VBA to the ThisWorkbook node and press F5 Sub ListSheetNamesInNewWorkbook() Dim objNewWorkbook As...

Share this:

Recent Content