I have a form called frmProjects. This form has a field on it called Department, which returns a 3 letter abbreviation for the department in field DeptID.
I want a button on this form, that when pushed will open the appropriate form based on the DeptID.
If DeptID = PNC, open frmPNC
If DeptID = STA, open frmSTA
If DeptID = TEL, open frmTEL
And there are 4 others.
It should leave frmProjects open, so all it needs to do is open the additional form.
My VB skills are very limited, but this sounds like it should be doable, I just have no idea how.
Any assistance would be greatly appreciated. My DB was ready for use until user-feedback dictated this button be created.
Please help.
I want a button on this form, that when pushed will open the appropriate form based on the DeptID.
If DeptID = PNC, open frmPNC
If DeptID = STA, open frmSTA
If DeptID = TEL, open frmTEL
And there are 4 others.
It should leave frmProjects open, so all it needs to do is open the additional form.
My VB skills are very limited, but this sounds like it should be doable, I just have no idea how.
Any assistance would be greatly appreciated. My DB was ready for use until user-feedback dictated this button be created.
Please help.