Repait or Refresh Sub Form

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
 
W

Wayne Morgan

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Sub form opens before the main form in MS Access 0
Refresh a form 3
Requery on a Tab Control - OnClick 3
Best way to refresh form data 1
Refresh, requery, or what? 2
recno,recordcounter,goto, refresh 1
System record,reccount,record number of the records in a table 1
How can I refresh data in a calculated field on my main form after sub form data changes? 5

Top