So I'm working on my final project for school and I want to try something cool my project. I want to make a form that has an option group at the top. The user can either select a radio button to 'add an employee' or to 'update/delete an employee.'
After they choose an option the form populates accordingly. If they want to 'add an employee' the form has all the column titles with text boxes for the user to fill out and a button below to add or to print the new employee.
If they choose to 'update/delete an employee' then the column titles appear again but the text boxes fill in accordingly depending on what Employee ID is select from a drop down box.
I've done things similar to this in C# but I don't see how to do this in Access. If this isn't possible or really isn't practical my second idea is to just have a form where you can select an Employee ID or a 'new' employee ID and the text boxes below populate (or remain blank) accordingly. Basically the user can select employee ID 4 and the first name, last name, address, etc etc fill in or they can select new and all the text boxes are blank. At the bottom of the form would be an option to save (either the update or the new employee) or to print the current form.
Thanks for any help and reading the lengthy post!
EDIT: If necessary the columns are:
Employee ID (Primary Key)
eFirstName
eLastName
SSN
EmployerName (foreign key to the employers table)
PlanID (foreign key to the insurance plan table)
ClassTitle
Address
City
State
Zip
Phone Number