SubDataSheet ability comes and goes without reason

[topmind]

In Access 2003, I have a query that uses a SubDataSheet. The problem
is that the plus sign [+] selection column sometimes shows and
sometimes doesn't. In fact, it seems to alternate when I open the
query view. For example, the first time I open it, the plus won't
appear, but it will the second time, but not the third, etc. Very odd
(pun).

Rebooting didn't fix it.

Thanks
-T-

 

[Evi]

I see you haven't had a reply to this yet. I suspect that this may have
something to do with your database design - for instance, it is connecting
to a number which ought to be unique but isn't always.
More on subdatasheets here.
http://www.vb123.com/Toolshed/00_access/subdatasheet.htm

It's usually best to take control of Access's built in features.
Evi

 

[Evi]

Also, ensure that none of the linking fields are Null by filtering them out
in your query. It's best to ensure that your subdatasheets are based on a
query and linked to other queries rather than directly on a table - but do
beware of this feature. It can slow down performance if used in tables. See
Allen Browne's article on this in
http://allenbrowne.com/bug-09.html

Evi

I see you haven't had a reply to this yet. I suspect that this may have
something to do with your database design - for instance, it is connecting
to a number which ought to be unique but isn't always.
More on subdatasheets here.
http://www.vb123.com/Toolshed/00_access/subdatasheet.htm

It's usually best to take control of Access's built in features.
Evi

In Access 2003, I have a query that uses a SubDataSheet. The problem
is that the plus sign [+] selection column sometimes shows and
sometimes doesn't. In fact, it seems to alternate when I open the
query view. For example, the first time I open it, the plus won't
appear, but it will the second time, but not the third, etc. Very odd
(pun).

Rebooting didn't fix it.

Thanks
-T-