Row Source SQL query question.

[Karen Hill]

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.

[Salad]

Karen Hill wrote:

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.

Usually you do something like this
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

[Larry Linson]

"Karen Hill" <ka**********@yahoo.com> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.com...

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.

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