Data environment: child-command problem

[VBmim]

I have set up a Data report with Data environment to work with an Access 2000 database. When I set up a command and a child-command at design-time it works fine, but when I want to set the sql-statements at run-time I get an "Invalid procedure call or argument" fault.

This is the code for the child-command:
DataEnvironment1.Commands("Dataquery&quot.CommandText = "select * from " & Tabelnaam & " order by sgroep"

The code for the command is
DataEnvironment1.Commands("groep&quot.CommandText = "Select distinct groep from " & Tabelnaam

Tabelnaam is a variable I use (I have to work with 6 different tables).

Can anyone help me?

greetings

Mim

 

[VBmim]

Found solution on my own...

This was what I had to do:
DataEnvironment1.Commands("groep&quot.CommandText = "SHAPE {select distinct groep from " & Tabelnaam & " } APPEND ({select * from " & Tabelnaam & " order by sgroep} as dataquery RELATE groep TO groep)"