Need Help Simplifying
Apr 1, 2008All:
What I'm trying to do:
I want to be able to use a switchboard button (or a button on a form) to open a unique form. OK, true, that's easy. Here is where I am having trouble. I want that one click to set the title of the form and the criteria for the query of a subform. Basically I want one form/subform/query to service multiple employees.
What I currently have:
I have a main form and two subforms, and multiple queries for each employee. They all do the same thing, display the same basic information but it all depends on the employee. If I make a simple change it takes hours to change all the forms for all the employees.
What I've done to find an answer:
I bought a Learn Access in 24hrs type book which got me to where I am now. I then purchased an Access VBA book and am currently about 1/3 of the way through that but still have no idea where to go.
I've searched through example databases to find one that does something similar but haven't found one.
I've done web and forum searches. I think my lack of success there is possibly due to not searching for the right things.
I've been experimenting on my own since November of 07.
I don't have a skilled friend I can ask.
There is probably a simple solution I just don't know where to find it.
Any help?
SeaRox