Good evening all,
I am new to using VBA in Access and have been tasked with creating updates for a tool at work. They want as much as possible to be based on VBA code due to the size of the tool/database we're working with.
I have a main report that displays the top 25 systems based off of a group number variable. I have another report that displays the top 25 part numbers that all belong to a certain group number. What I need to do is create a Subreport in VBA code for when the Group Report loads (on load) for the part numbers Report to be listed under their corresponding group number.
I know how to insert the subreport and all of that inside access itself and it works beautifully, but that's not what they're looking for. I also need to create a little plus thingy (very technical term) in the top left corner of the subreport to collapse or expand it, but I can manage that.....I think haha. Thanks for any input you guys can provide.
I am new to using VBA in Access and have been tasked with creating updates for a tool at work. They want as much as possible to be based on VBA code due to the size of the tool/database we're working with.
I have a main report that displays the top 25 systems based off of a group number variable. I have another report that displays the top 25 part numbers that all belong to a certain group number. What I need to do is create a Subreport in VBA code for when the Group Report loads (on load) for the part numbers Report to be listed under their corresponding group number.
I know how to insert the subreport and all of that inside access itself and it works beautifully, but that's not what they're looking for. I also need to create a little plus thingy (very technical term) in the top left corner of the subreport to collapse or expand it, but I can manage that.....I think haha. Thanks for any input you guys can provide.