What happened to QueryDef

  • Thread starter Thread starter AMCary
  • Start date Start date
A

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.
 
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.
 
Back
Top