Subdatasheets and Forms

[Hey Lucy]

I've searched and can't find an answer. I have a table (tblClientOffers) with a subdatasheet (tblNotes). Works fine.

I have created a form of tblClientOffers in datasheet view and placed it as a subform on another form (frmAllProps).

I would like to have the subform have the subdatasheet function, so that it would have the expand (+) and collapse (-) buttons and the user could expand to view the notes on each offer. (There can be multiple notes on a single offer).

Is it possible to get my subform to allow subdatasheet?

 

[FoundOil]

Hello,
I suspect that what you are trying to do may not be an included feature in a subform. I searched for a few minutes to try to verify that but I haven't found anything yet. I'm using Access 2010 and tried duplicating what you trying to do in one of my own databases and had the same result you did. As is mentioned in another subdatasheet post, there are better ways to display data that is is nested within your subform.

One solution that I have used is to create my subform as a continuous form and then put a command button to the right of the record which, when clicked, opens up another form with the related data. It is a much more elegant solution and is really quite simple.

 

[spikepl]

You two better both work on your search skills. 99% of issues have been dealt with before, which is why good search skills ARE an effort-saving tool.

http://lmgtfy.com/?q=how+display+subdatasheet