2007 subform container - continous forms

[Arpeggione]

I am converting an app from 2003 to 2007. In my app, I set the recordsource of a subform, then requery and a few records should show up. It works in 2003, but not in 2007. However, my query works in 2007 - the records are just not showing up in the continuous forms.

subfrmCtnr.recordsource = "SELECT...."
subfrmCtnr.requery

I'm stumped - any ideas?

thank you!

Karen

 

[Simon_MT]

I use the Source Object:

Function ArtistsEntry_PageNo()

'       This function is designed to speed up the Artists Forms, by making the History Pages and Consignments On Demand only

    With CodeContextObject
        .[Page No] = .[TabCtl0]
        If .[ACFlag] <> True And .[Page No] = 3 Then
            .[ACFlag] = True
            .[Artists Consignments].SourceObject = "Artists Consignments"
        End If
        If .[OHFlag] <> True And .[Page No] = 4 Then
            .[OHFlag] = True
            .[Artists Originals History].SourceObject = "Artists Entry Originals History"
        End If
        If .[GHFlag] <> True And .[Page No] = 5 Then
            .[GHFlag] = True
            .[Artists Prints History].SourceObject = "Artists Entry Prints History"
        End If
     End With
End Function

The flags are used so that once the subform has been initiated you don't need to do it again.

Simon

 

[Arpeggione]

Simon: I tried the Source object and it doesn't work either. I think this has something to do with the way things are displaying. I have this working correctly in another screen in 2007...

thank you for your comments.

karen