<div>
shane;<br />
<br />
Looks good, however when I run I get a method or data member found error on the .Forms<br />
<br />

</div>


shane;

Looks good, however when I run I get a method or data member found error on the .Forms



<div>
Ok.. I got it.. &nbsp;<br />
<br />
For Each frm in Forms ..<br />
<br />
Works so far.. thanks!<br />

</div>


Ok.. I got it..  

For Each frm in Forms ..

Works so far.. thanks!


<div>
Hmm, is this an ADP?<br />
<br />
Try this:<br />
<br />
Dim frm As Object<br />
For Each frm In CurrentProject.AllForms<br />
&nbsp; &nbsp;If SysCmd(acSysCmdGetObjectSt<wbr />ate,acForm<wbr />,frm.Name)<wbr />&lt;&gt;0 Then frm.Refresh<br />
Next<br />
<br />
Does that work?
</div>


Hmm, is this an ADP?

Try this:

Dim frm As Object
For Each frm In CurrentProject.AllForms
   If SysCmd(acSysCmdGetObjectState,acForm,frm.Name)<>0 Then frm.Refresh
Next

Does that work?

<div>
OK, if that fixes it, that's even better :)
</div>


OK, if that fixes it, that's even better :)

<div>
<div class="content wysiwyg-content">
Hi All!<br />
<br />
In a project, I have several forms and at any one time two or more forms can be open. Is there a simple method for refreshing the data on all open forms?<br />
<br />
Thanks!<br />

</div>
</div>


Hi All!

In a project, I have several forms and at any one time two or more forms can be open. Is there a simple method for refreshing the data on all open forms?

Thanks!


refresh all open forms

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.