query parameters. OOps!! I don't get again.

[vanleurth]

Hi Everybody,

I haven't found good literature on the diference between fields and parameters for the QueryDef object. Therefore, I've decided to ask someone out there.

I'm trying to link a query to a form text but I'm getting a message that says

- Item not found in this collection
In the line that has >> (see below)

Here my code ...

Dim qDef As QueryDef

' Assign the query to the query object
Set qDef = CurrentDb.QueryDefs("qry training schedule attendees action&quot

' Define the variable
>> qDef.Parameters("GroupID&quot = Me!GroupID
qDef.Execute

Thanks for any help or suggestions
Vanleurth

 

[vanleurth]

Never mind people. My fault, I haven't read the crosstab query section in my book yet. Therefore I have no parameter defined.

 

[vanleurth]

Well that didn't help ...

I'm still working on it ..

Should I use the fields object of my query object ?
Let's try.

V.