Does anyone know if there is a way to use a SQL statement for a sub form. Or some way to use a recordset or querydef (that is not a created query object)? Because you can use objects like queries or tables as your sourceobject for your sub form, I was hoping that I would could in some way use a SQL statement (that is created dynamically).
Any ideas anyone? Any help would be appreciated. Thanks.