Check out the form SubdatasheetExpanded property.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
I did. It is set to no, which means the sub data sheets are just simply not shown automatically. If I set it to Yes, it shows the expanded sub data sheet. I don't just want to not expand the subdatasheet, I want the (+) option to not be there.
Interesting, I get the + when I open table but not in form bound to table. This form is in frontend. I don't have relationships set in the frontend. So I went to backend where I do have relationships. I created form on the same table and this one does show the +.
I tried setting this form to Continuous View but won't let me because of subdatasheet.
The form in frontend can be set to Continuous View.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
I cant set front end form to Continuous View because of sub data sheet. I cant delete the relationship because it is inherited.
Not sure what you mean by inherited.
I am able to set my frontend form to Continuous View.
Oh wait, just hit me - split form. I never use.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
That's the wording of the error.
The users of this database are accustomed to split forms.
Sorry, then the only solution I can see is to not set Relationships.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.