I have a database that tracks my customers and the projects they request. I currently have created a form with my customers information and inserted a subform that shows a list of every project I'm working on for that customer.
Here is what I want to do:
I want to remove this subform and turn it into a button I can click that opens a new window with a list of that customers projects. I want to be able to edit (edit, remove, and add) the projects for that customer.
What I have tried so far:
I tried adding a button that opened the subform but instead of just showing the projects for that customer, it shows all the projects for all my customers.
Any advice on how to do this is greatly appreciated. The only knowledge I lack is Visual Basic and Macro's (I know..."only" is a strong word).
TIA for all your help.
-Justin