Good day everyone. We have an Access DB that I have been tasked with changing a bit. I have made some changes and addition to it as well as redesigned one of the forms. I have two issues (one is actually a question)
1) There is a form that we run to produce all of the information requested for a specific amployee. Ever since I added the field "Notes" it now requests to enter a parameter value when the button to Preview or Print to the reports is clicked on. I am including a screenshot as well as a copy of the DB. This is on Untitled.jpg
Can anyone tell me how to get rid of the prompt or why no matter what I enter in the prompt, I can't get data to view on the report anymore?
2) We have a form (the same form above) that I believe the Build Events could be done a bit differently. This is on Untitled1.jpg. Currently when the Preview or Print button or selected, it goes through a Case statement to figure out what employee was selected. We have a table labeled Team member that houses all of this information.
Is there anyway to rewrite the code of the build event (there are two the are similar) so that it queries the table instead of having to make changes to those build events everytime a new employee is added to our company?
Any help is greatly appreciated. If anyone needs further information, please let me know. I didn't want to post the entire database because I didn't want it out for the public to see.