What happened to QueryDef

[AMCary]

I am trying to write an sql statement in a form event procedure. The command
"Dim xxx as QueryDef" no longer seems to be exceptable syntax in Access 2007,
despite its appearance in the Northwind examples. How do I define a query to
call, if this doesn't work. BTW I have successfully written the sql to
function as a where command in a report opening DoCmd, but in this case I
want to open a RecordSet that is the query, but using input from a form to
define the where condition.

 

[AMCary]

Where do I find the Tool Refernences Dialog Box. BTW I hate the new Access!
Allen

 

[Bob Barrows]

Open a code window - does ctrl-g still do that in A2007?
Once you have a code window open, you can set the references for the
database.