I have a "master" form that the user inputs common data (address, phone, etc) for everyone in a school system (FrmEveryone)--"1" side. Everyone placed in the database is classified in a combo box as either an "employee" or a "student."
Once this classification is made, I have two command buttons that require the used to select one of two additional forms -- one for data unique to an employee(FrmEmployee)--"many side" and the other for data needed on students (FrmStudent)--"many side".
My question is this: How do I "automate" going from the master form to the appropriate form when the user selects either "employee" or "student"? Can this be done without the user "interacting" with command buttons?
I would like to see this done with Macros (I am studing them now) but realize that VBA (which I do not yet know) is a better approach. Obviously, I am a novice so please move very slowly and make no assumptions.
I can follow directions. Thanks in advance!
Once this classification is made, I have two command buttons that require the used to select one of two additional forms -- one for data unique to an employee(FrmEmployee)--"many side" and the other for data needed on students (FrmStudent)--"many side".
My question is this: How do I "automate" going from the master form to the appropriate form when the user selects either "employee" or "student"? Can this be done without the user "interacting" with command buttons?
I would like to see this done with Macros (I am studing them now) but realize that VBA (which I do not yet know) is a better approach. Obviously, I am a novice so please move very slowly and make no assumptions.
I can follow directions. Thanks in advance!