I'm trying to create a search form that has a subform (2, actually, depending on the table) and want to get its last recordsource for refining results using the main search form. To do that, I need the SQL string. When I use the line below, it works great if the recordsource is a SQL statement, but if it's a query, it just hates me.
Set QDF = Currentdb().CreateQueryDef("qryETemp", SFE.RecordSource)
Can someone tell me the proper logic so I can get this string?
Thanks, you guys ALWAYS rock!