QueryDef Type=3?

[PearlGI]

Does anyone know what a QueryDef Type of 3 is?

If I run the following code, as well as returning all queries in the db, it also returns a few that are of Type=3.

For Each qd In db.QueryDefs
    Debug.Print qd.Name & " - " & qd.Type
Next

For the Type 3 ones, the qd.Name returns something like

~sq_rREPORTNAME
where REPORTNAME is the name of a report in the database .

However, it's only a couple of reports that appear this way.


Where or what is a Type 3 - even if I view Hidden & System objects I can't see them!

 

[Pat Hartman]

The names that start with ~ are queries that Access created on your behalf as the RecordSources of forms/reports and RowSources of Combos/Listboxes.

Since stored querydefs are more efficient than SQL strings, Access actually creates a querydef even though you entered an SQL string directly.