MS Access 2007 unbound subform comes up blank

[ISUTri]

Hi, we recently converted to Access 2007 and I am having trouble with one of my forms. I currently have a form where you enter search criteria in and hit "Search" the form builds a query and then uses an unbound form to display the query results. However, when I login as a user this form is blank (nothing shows at all). Are there any security issues with Access 2007 that I need to take into account when doing this?

The portion of the code that assigns the query to the subform is as follows, this works when I run it myself:

Me.subfrmQueryResults.SourceObject = "Query.qselTEST"

Thanks

 

[LisaWay]

Are you saying that when you first open the form, the contents of the subform is blank? Or are you saying that when you first open the form, no controls are visible whatsoever? The contents of the subform would be blank initially if its source object was blank, but you should still see its border (assuming that it has a non-transparent border!).

Regards,
Lisa