Not sure that the title best describes what I am trying to do (or that this is the right section of the forum) so I will provide as much detail as possible. This is my first post here!
Using Access 2003 currently. My database tracks practice exams for employees. There is a table that contains the exam data and a table that contains the employeed data (one-to-many relationship between employee > exam tables).
I have a dashboard form that is displayed when users open the database. There is a button on the dashboard that allows a user to search by a specific employee ID via a pop-up box (criteria) that drives a query. The data about the employee is displayed in the top of the form [query against the Employees Table]. The bottom of the form contains a subform with the exam detail [query against the Exams Table] that exists for that employee. The tables are linked by the Employee ID.
What I am trying to do (and am totally stumped on the best way to approach it) are the following:
1. Hide the subform if there is no exam data for the employee ID entered in the pop-up box - I tried the 'can shrink' property but it didn't work and subsequently....
2. If there is no exam data for the selected employee, possibly display a different form (identical to the existing form but with a different background color) with two new fields/controls (Checkbox and date field) and no subform.
When this new form is displayed and the a) box is checked and b) a date is entered in the new date field, these two fields in addition to the employee ID are saved to a new, separate table that I can run a query/report against later.
I am not new to Access, and am somewhat familiar with modifying VBA code to accomplish more complex tasks, but this change has completely got me stumped. Any assistance would be appreciated!