Show drill down of data in a report or form in Access 97
Posted on 2005-03-29
I need help with this urgently. And if at all possible I need to do this with out any VBA.
I have a query called AttachmentInv. It contains the fields IntCustNo, Model,Serial, and Div.
I need a form/report or form I can mak look like a report that will allow the user to select a IntCustNo and for the drill down to diplay the Model(s) that are assigned to that IntCustNo. Then when you click on the Model, it would list the Serial, Div...etc.
I have tried doing this in a form with a subform, but it is not "refreshing the data" when I change the IntCustNo. So I am willing to start from scratch with any new ideas.
Thanks in advance for your help.