I was tasked with revamping my companies Access Data base for part specs. I am having an issue figuring out how to make it all gel together. Below is how I would like it to function.
A Form for Each Customer. Customer ID will be the only unique field for each Customer form. Each Customer form will have the same 6 buttons.
When a button is clicked I would like to spit out a report based on the Customer ID that is on that form and the button Caption.
For Example Customer A Form is open. Button 1(Name) is clicked. Report is opened from the main table with only data for Customer A and Button 1 (Name)
I appreciate any help you can give.