* BUG * - Datasheet + SubDatasheet fails

[Atlas]

Just read about (form) datasheet view + subdatasheet, + sign, expanding
subdatasheets, etc.
Just made one.
Placing the subform control in the footer wouldn't work at all (no + sign)
Placing the subform control in the detail section, makes the + sign visible
but when clicking on it to expand the subdatasheet, I get the following
error:
- "The column prefix 'mytablname' does not match with a table name or alias
name used in the query."

Facts:
- the relationship one to many exists;
- the subdatasheet property is set to [Auto] for both tables;
- the link child/master fields have the proper fileds name;


Comments from MS appreciated.


================================================================
Windows XP + SP2
Access 2003 + SP1,
..adp project,
ADO 2.8,
MS-SQL Server 2000 + SP3a

 

[Steve Jorgensen]

Just read about (form) datasheet view + subdatasheet, + sign, expanding
subdatasheets, etc.
Just made one.
Placing the subform control in the footer wouldn't work at all (no + sign)
Placing the subform control in the detail section, makes the + sign visible
but when clicking on it to expand the subdatasheet, I get the following
error:
- "The column prefix 'mytablname' does not match with a table name or alias
name used in the query."

This is a bug that happens sometimes in subforms and subreports. You can
usually fix the problem by editing the SQL, and removing the table name
qualifier from each expression in the ORDER BY clause. MS says they fixed
this bug, but I still see the problem.

 

[Atlas]

This is a bug that happens sometimes in subforms and subreports. You can

usually fix the problem by editing the SQL, and removing the table name
qualifier from each expression in the ORDER BY clause. MS says they fixed
this bug, but I still see the problem.

Still noticeing too many bugs!

Steve thanks for answering.... BTW do you use any custom control ina access
to have more speed and flexibility, like tree view etc.?