Subdatasheets - getting value

[GingerR]

Hi. I need to know how to get the value from a query when a user has clicked in a record.

I have a set-up where when a user clicks a button on a form, there is a query displayed, with 5 subdatasheets. They navigate down thru the subdatasheets.

I would like when the user clicks a value in the fourth subdatasheet, that a report opens showing the details of that record (the same details that are displayed on the fifth subdatasheet, only on a report so they can print it out). Of course since queries don't have events, i made a toolbar, hoping that what could happen is that the user clicks on the record in the fourth subdatasheet that they want a report of, then hit the toolbar button, that the report opens showing just the record that they've clicked on, along with its details. but I don't know how to get the value from the query. There's nothing like this "Queries!QueryName!subQueryName!....subsubQueryName.FieldName" set-up for queries like there is for forms and reports.

Thanks--

 

[LonnieJohnson]

Why not show these queries as datasheet forms? Then you can use your event processing.

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[GingerR]

I tried making them as forms, but i remember that because of all the subdatasheets, each subdatasheet width and the width of all the columns isn't flexible like it is with queries/tables. I just tried doing it again and I can't even make the first form show the little plus signs that indicate that a subdatasheet is included.