How do I include a where clause that contains a form value in a Row
Source SQL query? This is in the form properities under DATA.

SELECT [Categories].[CategoryName] FROM Categories WHERE Catogories.id
= Me![id];

The "Me![id]" is a form control.

Karen Hill wrote:

Dim strSQL As STring
dim rst As Recordset
strSQL = "SELECT [Categories].[CategoryName] " & _
"FROM Categories " & _
"WHERE Catogories.id = " & Me![id];
set rst = currentdb.openrecordset(strSQL,dbopendynaset)

If you are in the query builder, you need to know the name of the form
SELECT [Categories].[CategoryName] _
FROM Categories _
WHERE Catogories.id = Forms!YourFormName!ID

"Karen Hill" <karen_hill22 (AT) yahoo (DOT) com> wrote

The "Me" shorcut notation can only be used in VBA code in the Form's or
Report's module. To use such a reference in RowSource (or in an expression
in a Control's ControlSource), you have to use the fully-qualified
reference, such as

Forms!frmYourForm!id

Larry Linson
Microsoft Access MVP