L
LF
I successfully implemented Allen Brown's Audit Trail functionality on a
continous primary form. I also created a button in the header of this primary
form that opens a secondary datasheet form that is based on the audit table
as well as filters the display of audited records to those relevant to the id
of the currently selected primary record using the following code within the
button's OnClick event procedure.
...
stDocName = "frmREQAudit"
stLinkCriteria = "[RFPid]=" & Me![txtRFPid]
DoCmd.OpenForm stDocName, acFormDS, , stLinkCriteria
...
I now want to synchronize the filterization of the datasheet as the primary
record selection changes. I realize this is common subform functionality but
I don't want the secondary datasheet to continously display. I want the
ability to close the datasheet as well.
I tried placing the datasheet as a subform in the footer of the primary form
intending to make the header button toggle the footer visability. But doing
so only displays a single primary record at a time; loosing the continous
functionality even if the primary form is expanded.
Any recommendations as how to go about accomplishing this would be
appreciated.
continous primary form. I also created a button in the header of this primary
form that opens a secondary datasheet form that is based on the audit table
as well as filters the display of audited records to those relevant to the id
of the currently selected primary record using the following code within the
button's OnClick event procedure.
...
stDocName = "frmREQAudit"
stLinkCriteria = "[RFPid]=" & Me![txtRFPid]
DoCmd.OpenForm stDocName, acFormDS, , stLinkCriteria
...
I now want to synchronize the filterization of the datasheet as the primary
record selection changes. I realize this is common subform functionality but
I don't want the secondary datasheet to continously display. I want the
ability to close the datasheet as well.
I tried placing the datasheet as a subform in the footer of the primary form
intending to make the header button toggle the footer visability. But doing
so only displays a single primary record at a time; loosing the continous
functionality even if the primary form is expanded.
Any recommendations as how to go about accomplishing this would be
appreciated.