MichaelSwitzer
asked on
Access detail object properties
Hello,
I'm trying to understand/ figureout how to display (for edit) multiple subsets of data. For example: a subform within a subform. Access 03 will only allow the developer to create one subform deep, however, I need a little more functionality.
Another related issue: On a subform (in the detail body (Continious form)), I need a command button (listed in every detail item) to either be visible or invisible depending upon a return from a query. Is there is way to hide and show select command buttons for each detail item. (Example: Continious form with an employee listed in each detail. If notes exist for the employee (in a separate table) then the 'show notes' command button is visible/ enabled etc.. Again, the problem occurs when a particular object's visible property is set to false, ALL of the objects in every detail item have visible properties set to false. )
I'm trying to understand/ figureout how to display (for edit) multiple subsets of data. For example: a subform within a subform. Access 03 will only allow the developer to create one subform deep, however, I need a little more functionality.
Another related issue: On a subform (in the detail body (Continious form)), I need a command button (listed in every detail item) to either be visible or invisible depending upon a return from a query. Is there is way to hide and show select command buttons for each detail item. (Example: Continious form with an employee listed in each detail. If notes exist for the employee (in a separate table) then the 'show notes' command button is visible/ enabled etc.. Again, the problem occurs when a particular object's visible property is set to false, ALL of the objects in every detail item have visible properties set to false. )
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
More specifically, there exists a Main form with form view, a subform with continious view, and i would like for a second subform (within the first) with a continious view.
To do what you proposed, I would need to create a query (this program's front end written in Access and back end in MSSQL05) that checks a related table and sets each field's value to "Show Note" or (or what have you) and set a text box control source to the qry's filed name holding the 'Show Note' string.
Is this what you mean?
(ps. I liked your Nz expression.)
To do what you proposed, I would need to create a query (this program's front end written in Access and back end in MSSQL05) that checks a related table and sets each field's value to "Show Note" or (or what have you) and set a text box control source to the qry's filed name holding the 'Show Note' string.
Is this what you mean?
(ps. I liked your Nz expression.)
part 2: in essence, yes.
Can you swith from continuous form to datasheet? they can have subdatasheets.
Can you swith from continuous form to datasheet? they can have subdatasheets.
ASKER