SourceObject Malfunction (1 Viewer)

Hey Guys,

Weird Problem:

I have a subform with the SourceObject set in properties.

The first time the form opens, the Subform Control is blank
in subsequent openings it works.

The querydef behind the form will run, displaying all of the current records.

I can set the SourceObject in code and it works fine.

I have imported the form back into the Database to see if that corrected the problem to no avail.

I ran compact and repair and the code has been debugged.

Thanks all.

Execute a Me.Refresh statement immediately after the statement setting the SourceObject Property value.

Thank you,

That is what I ended up doing.

I should have returned earlier, and mentioned it.