I am developing an access 2002 application.
I have the following piece of code:

    Dim objCurProj As CurrentProject
    Dim objAcObj As AccessObject
    
    Set objCurProj = Application.CurrentProject
    
    For Each objAcObj In objCurProj.AllForms
        If objAcObj.IsLoaded = True Then
            Debug.Print objAcObj.NAME & " OPEN"
            objAcObj.Requery 'PROBLEM HERE
        End If
    Next

I am trying to call the requery method for any open form. The problem
is that I do not know how to reference the method based upon the value
I receive from the all forms collection.

Can you tell me how to accomplish this and let me know the logic
behind it?

Brian Selltiz
Digital Provisions

Forms(objAcObj.Name).Requery 

The Forms collection has all the currently open forms.  It can be
indexed by name to get a particular Form. You can then use any methods
or properties of the Form.
Once IsLoaded returns True, then you know that the Form is available
in the Forms collection.

Please ask for clarification if you need further details. Good luck
with your database!

---

Request for Answer Clarification by bselltiz-ga on 31 Oct 2002 12:03 PST

Hey,
I need clarification on the correct syntax.
I tried the following code with no success:

    For Each objAcObj In objCurProj.AllForms
        If objAcObj.IsLoaded = True Then
            Debug.Print objAcObj.NAME & " OPEN"
            strName = objAcObj.NAME
            objCurProj.AllForms(strName).Requery
            objCurProj.AllForms(objAcObj).Requery 'doesn't work either
            objAcObj.Requery
        End If
    Next

Thanks for your help.

Brian

---

Request for Answer Clarification by bselltiz-ga on 31 Oct 2002 12:05 PST

geez, I'm a dope.
I missed the first line of your answer, sorry.
It works fine, thanks :->

---

Clarification of Answer by hammer-ga on 31 Oct 2002 12:19 PST

The first line is kind of lost agaianst the answer header. I'll have
to remember to put a blank line at the top of my answers!

---

Clarification of Answer by hammer-ga on 01 Nov 2002 04:43 PST

I see that you rated my answer at four stars. While you cannot alter
your rating, if there is some additional piece of information that you
need to make this a five star answer, please post a request for
clarification and I will be happy to attempt to provide it.

hammer-ga