Little plus sign on related tables? 1

[Sheco]

Whats up with the little plus sign on related tables? The one where clicking it shows field values from the other table? Is there a way to prevent this from happening?

 

[PHV]

When in design view of the table look in the properties sheet at something like 'Sub datasheet'

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Sheco]

Well I guess I underestimated the power of google!

My search was: Access "little plus sign"

I found out they were called Subdatasheets and you can remove them by opening the table in Datasheet mode (where you see the current rows, not the design mode) and then a menu option appears labeled Format appears...

Format -> Subdatasheets -> Remove

 

[Sheco]

Ah, I guess I was typing at the same time you were... Still I think it rates a star.