Cannot create subdatasheet

[Guest]

I have a front end and back end database in Access 2002-2003 format. All tables in the back end are linked in the front end. The backend displays subdatasheets automatically, however, I cannot get them to display on the front end. The subdatasheet function under the Insert menu is grayed out, and trying to change the View properties for the table does not work. Do I need to modify settings somewhere? I could not find anything in Microsoft support indicating that linked tables could not have subdatasheets. Thx.

 

[Tim Ferguson]

The backend displays subdatasheets automatically, however, I cannot
get them to display on the front end.

The best advice is: just don't use them! It is simply not nice to present
table datasheets to your users -- there is so little control over what
happens.

Design forms -- that, after all, is what they are there for. In that way
you can control events, carry out proper validation, restrict what you
don't want to be seen, and so on and so on. If you are really addicted to
the grid layout, you can either use Continuous Forms or Datasheet views.

The only reason to be interacting with table datasheets is for testing and
debugging.

B Wishes


Tim F