Repait or Refresh Sub Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do you repaint or refresh a sub form when clicking on a button on the main form.
The main form contains criteria that is used to build the query.

The following code gets the following error: Object doesn't support this property or method - 438

Forms![frmSelectCriteria]![frmSelectedDataSheetForm].Refresh
 
You probably don't want to Repaint, you probably want to Requery or Refresh.

Me.NameOfSubformControl.Form.Requery

The NameOfSubformControl is the name of the control on the main form that
holds the subform, not the name of the subform itself.
 
Back
Top