Home  |  About  |   Search   

What's New
Table Of Contents
Credits
Netiquette
10 Commandments 
Bugs
Tables
Queries
Forms
Reports
Modules
APIs
Strings
Date/Time
General
Downloads
Resources
Search
Feedback
mvps.org

RunCommand Constants

Terms of Use


 

Queries: Use a variable in a field's criteria

Author(s)
Erika Yoxall

(Q)    Can I use an Access Basic variable as a criterion in a query?

(A)     The only way to refer to an Access Basic variable is by using Access Basic code. therefore, you need to create a function that equals the value of that variable, it could look like :

function GetValue()
  getvalue = variablename
end function


1998-2009, Dev Ashish & Arvin Meyer, All rights reserved. Optimized for Microsoft Internet Explorer